Conditional formatting of "start date" vs. "actual start date"

CMM_SDVI

Hi, I have columns for "start date" and "actual start date". If I manually enter an actual start date and it's PAST the proposed start date, I would like that row to have red font. I can't see a way to do this.

Using any date column it seems the only option is to use an actual date in conditional formatting.

Any suggestions?

thanks!!

cmm

Paul Newcome

You would need to insert a helper column with a formula in it to output some value when the condition is met then use this helper column to trigger your conditional formatting.

CMM_SDVI

Interesting. Thanks Paul, I'll give it a try!

Paul Newcome

Happy to help. 👍️