Conditional format using two columns

Yovanka Barnard

Hi,

I have two columns Planned start and Actual start.

I can't seem to set a conditional formatting rule when Planned start is not equal to Actual start.

Please assist.

Find more posts tagged with

Construction

Conditional Formatting

Project Management

Comments

Jeremy Myers

1. Make sure both source columns are formatted as date.

2. Insert a third column called "Calc Start Date" or something suitable and dump in the formula.. The below checks to see if there is a difference in the two dates.

=IF([Due Date]6 <> [Actual Start]6, "Not Planned Start", "OK")

3. Set conditional formatting to read the result if "Not Planned Start Date" and display red over the actual start date cell.

Yovanka Barnard

Thanks. This is really helpful.