Actual date against Original Date Conditional Formatting

Nancy Pet

Q: What is conditional formatting to have Actual: WB Completed date match up against Workbook completed date? Then shade it red if late, no font change if before or on that date

See picture for visuals and thank you in advance for your time.

Samuel Mueller

@Nancy Pet you are probably going to need a helper column.

Helper column would have a column formula something like

=IF([Actual: WB Completed]@row >= [Workbook completed]@row, 1 ,0)

Then, conditional formatting will be if helpercolumn = 1, shade red. helper column would be the column you select in the conditional formatting box, criteria will be equal to 1, and then you would apply the format to the column you want to show to format.