If/then question with color formatting

Cyndi

This is what I am trying to accomplish. Is there a way through conditional formatting or any other options

Screen Shot 2021-08-12 at 2.07.14 PM.png

• If [Report Submission Date] is greater than [Report Due-10] then Report Past Due Flag should be RED
• If [Report Due Date-10] is in the past AND [Report Submission Date] is blank, then Report Past Due Flag should be BLUE

MCorbin

You can format your "Report Past Due" field as a Symbol column type. Based on your colors, I selected the 4 color balls symbol type:

Which gave me these results:

Using this formula:

=IF([Report Submission Date]@row > [Report Due-10]@row, "Red", IF(AND([Report Due-10]@row < TODAY(), ISBLANK([Report Submission Date]@row)), "Blue"))

MCorbin

You could also use the "color" column as a helper column, and set conditional formatting to format the Report Submission date column based on whether the Color column says "Red" or "Blue"

Cyndi

Thank you so much! I like using the dots it's more eye catching.