I want to make an have an entire column formatted with a conditional formula. Column K is conditional on whatever is in column J. The thing is I want the entire column to be formatted Only if it has a date inside. What I have not keeps formatting cells in K when J has nothing in it.

Conditional formatting
Rule 1: =TODAY()-J2=30 with Text Red
Rule 1: =TODAY()-J2>30 with filler Red

I want to continue that formatting but not if the date column is blank. I was thinking the way to do this is with the following formula.

=IF(NOT(ISBLANK($J1)))
It says error though ????

Attached Files

Test.xlsx (10.8 KB, 9 views)