SharePoint List Column Styling 102

Column Styling 101 only shows you a single option for colour formatting.

For this example, I want it to only be red if the date is past AND the item is not competed.

So like before you need to open the column formatting properties.

• Click the drop-down arrow next to the column you want to see.
• Select “Column settings”
• Click “Format this column”

• This opens the column formatting properties
• Untick “Format dates” and Select “Conditional formatting”

• Then click “Manage rules”

• Now we add our new Rules:
• Click “Show all values as”

• Then add the new rules:

• Click “Save”, and back
• Add all 3 conditional rules

• The view will now not show the colour if the task is completed