Highlight date cell in a colour if blank and date has passed in another date cell
We have several date columns that need to be compared and highlighted if dates have passed and corresponding column row does not contain a date.
Image shows 'Site Completion Forecast' with a date that is in the past. The 'Site Completion Actual' Column is blank for this row and needs to be highlighted (Red if possible).
I tried this formula but get an #unparseable
=AND(NOT(ISBLANK([Site Completion Forecast]@row), ISBLANK[Site Completion Actual]@row, [Site Completion Forecast]@row<=TODAY())
I also tried using an Automation but it doesn't let you update the value of a Date Column.
Help Article Resources
Check out the Formula Handbook template!