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?
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
