Conditional formatting based on date column entry being past another date column entry.

Christian Andersen

 I have Finsh date clearly and have put another column for Actual finish.  If the Actual date is before or after the original Finish date I would like to be able to format it.  Is there a way to do this?

J. Craig Williams

Christian,

 

By formatting, you likely are looking for Conditional Formatting.

You can't use formulas directly there, so you need another column.

 

A checkbox column with this:

 

=IF([Actual]23 <> [Actual finish]23, 1)

 

will set the check box true when the Actual and Actual finish are different.

You can then use Conditional Formatting on that field.

 

Hope this helps.

Craig