Forum Discussion
Solved
Conditional Formatting if date is past And Cell is Blank
Hello, Am trying to find a formula that works if a date is past today's date and the another cell is blank to highlight the date cell red, until the blank cell is filled.
The rule for conditional formatting and the applied range must start in the same row.
In the attached example i have the rule:
=IF(AND($H2<TODAY(),$J2="",NOT(ISBLANK($A2))),1,0)
and the applied range:
=$2:$50
The applied range can easily be adjusted to e.g. =$2:$5000 but always keep in mind that rule and applied range start in the same row.
The other rule in attached sheet is:
=$H2>TODAY()
and the applied range is:
=$2:$50
With this and some more research, I was able to achieve my goal. Thank so much for the replies!