Conditional Formating based on Date

[Kimti]

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.

 

[Per Jessen]

Change condition 1 to:

=AND(A1<=TODAY(),A1>0)

Regards,
Per

 

[Kimti]

Thank you for quick response. I set as you described, but the blank is also
showing yellow color. Even past date is showing yellow color. Please provide
further help for this.

Kimti

 

[Kimti]

Now blanks are showing yellow. Please help.

Change condition 1 to:

=AND(A1<=TODAY(),A1>0)

Regards,
Per



.

 

[ck]

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.

 

[ck]

Hi Kimti,

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

Click yes below if it works.