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