use an AND formula

=AND(A1<"",A1<TODAY())

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Doo0592" wrote in message
ups.com...
Hi all,

I am setting up conditional formatting to change the interior colour
for a row to red when a date passes. This I can do but I cannot figure
out how to not have the cells change when No date is input.

Any help appreciated

Thanks x