Date Conditional Formatting
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
|