How To Ignore Blank Cells with Conditional Formatting

Hi,

I have a spreadsheet (attached) where column (G) is a list of dates and I want them to turn green when the date is older than 180 days from today. So I have the CF set as =G2<+TODAY()-180 with the cell set as green, but the blank cells are all green too. I have tried a few different =AND and NOT(ISBLANK) formulas for this and I can't nail it!!!

Can anybody help so that the cells with the dates older than 180 days go green but all others, including blanks, have no formatting?

Cheers
Glenn
CSO Completion Test.xlsx

I didn't download your file.

Maybe like this...

=AND(COUNT(G2),G2<=TODAY()-180)

COUNT(G2) makes sure there is a date (number) in the cell.

You're welcome. Thanks for the feedback!