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

Hi

Choose as rule cell value between ---> 0.5 AND $AQ$3

Be aware: Cond. Formating slows down calculation significantly if applied to huge ranges.