Conditional Formatting for Dates

happinessisland

I have two columns, one with a projected date and one with an actual date. I want the actual date to turn red whenever it is later than the projected date. How would I make this happen?

Kerry St. Thomas

With a helper column. Create a column that does that evaluation:

=IF([Actual Date]@row > [Projected Date]@row,"Bad Date","")

Then you can create a conditional format that turns the Actual Date red if the helper column says "Bad Date".

Kelly P.

@happinessisland You'll need to add a backend helper column that checks itself when the actual date is later than the projected date and then use that helper column to run the conditional formatting (if box is checked, make the actual date red).

Hope this helps!

Kerry St. Thomas

With a helper column. Create a column that does that evaluation:

=IF([Actual Date]@row > [Projected Date]@row,"Bad Date","")

Then you can create a conditional format that turns the Actual Date red if the helper column says "Bad Date".

happinessisland

Thank you so much @Kerry St. Thomas & @Kelly P. !!!!!!!

Kelly P.

@happinessisland Happy to help! 😊