Excel 2003 Conditional formatting help Closed

Question

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

venkat1926 · Answer

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.

danno · Answer

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

venkat1926 · Answer

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.

Excel 2003 Conditional formatting help

3 responses

Similar discussions

Subscribe To Our Newsletter!