Forum Discussion
Conditional Formatting with Dates
How do I format so that certain adjacent cells will highlight if one of the cells is before current date. B4 C4 D4 ...
Select B4:F4 and make a New Rule for Conditional Formatting using the formula given below and set the format as per your choice.
=$F4<TODAY()