Excel 2003 Conditional formatting help

Closed
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
Hello,

trying to highlight a date that is 5days old, than a differnt color for 10 days old and a different color for 15 days old.

For instance, I sent the mail out on Jan 7 it is Jan 13. I want this cell to highlight yellow because it is 5-9 days old

For instance, I sent the mail out on Jan 2 it is Jan 13. I want this cell to highlight green because it is 10-14 days old

im not able to get it down right... any help is appreciated

3 replies

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
suppose A2 has the entry of the date
In the conditiona format window
condition 1 is
on the left window click the small arrow and choose
"the formula is"
and on the right window type
=AND(TODAY()-A2>=5,TODAY()-A2<=9)
and click formt and choose color under PATTERN

then in conditon 2 choose
the formula is
and on the right side window type
=AND(TODAY()-A2>=10,TODAY()-A2<=14)
clcik ok twice

copy A2 down pastespecial format only.
for some reason it is still not working. When i first apply the conditional formatting it highlights the 5-9 correctly, but not the 10-14. And when i add a new 5-9 date even after copying and pasting all the way down to the 200th cell it does not highlight it
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
My sample data is

by following what I told you in my posting I got correctly
mine is excel 2002 but it should work in 2003 also.
check your steps again
after you put the first condition and color click once ok
after the second condition is put and color click twice ok
I do not know where the error occurs.


hdng 
25-Dec-09
28-Dec-09
31-Dec-09
2-Jan-10  green
3-Jan-10green
4-Jan-10gree
5-Jan-10green
6-Jan-10red
7-Jan-10red
8-Jan-10red
9-Jan-10red
10-Jan-10red
11-Jan-10
12-Jan-10


so it comes alright.