Hi Kimti,

Try this to see if works:
condition 1: =AND(A1<=TODAY(),A1<"")
condition 2: =AND(A1-TODAY()<10,A1<"")

Click yes below if it works for you.

"Kimti" wrote:

Now blanks are showing yellow. Please help.

"Per Jessen" wrote:

Change condition 1 to:

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

Regards,
Per

On 7 Mar., 21:47, Kimti wrote:
I would like to change the cell color based on date. For example if date is
today or less color should be red, if date is upto 10 days from today the
color should be yellow. I used following:
Condition 1: =A1<=today() RED
Condition 2: =A1-today()<10 YELLOW

it worked ok if I have date in the cell. If the cell is empty, it is still
showing me RED color. I want see no formatting if the cell is empty.

Thank you in advance for your kind help.

.