Conditional Formatting Help Needed...
 

Ah ha... =AND($Q3<"",$Q3<=TODAY())

....figured it out... guess I just had to spell it out better than before. Thanks!

"John" wrote:

Trying to get this across to Excel:

IF Cell is not blank, AND is today's date or earlier THEN turn cell red.

I can get it to work if all cells have dates in them, but when the cell is blank it turns it red by default. I need blank cells to remain untouched.

Thanks, John.