On my spreadsheet i have this Formula =TODAY() in cell AQ3 which links to cell E6 =COUNTIF(F$11:F$65536,"<"&AQ3)



The formula basically counts how many cells in Column F (from a certain point) are less than todays date

I have a conditional formatting set up so that any cell in Column F which is less than todays date <$AQ$3 will automatically highlight in a certain colour. The only problem that i have is all the cells i have selected for this conditional formatting, it also highlights the blank cells.

Is there a way where i can keep the conditional formatting so when the date is less than todays date it highlights the cell, but not the blank ones?

Any help will be grateful