Conditional Formating based on Date

K

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.
 
K

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
 
C

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.
 
C

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top