Excel 2003 Conditional formatting help
Closed
danno
-
Jan 13, 2010 at 01:34 PM
venkat1926
venkat1926
- Posts
- 1864
- Registration date
- Sunday June 14, 2009
- Status
- Contributor
- Last seen
- August 7, 2021
Related:
- Excel 2003 Conditional formatting help
- Excel count conditional formatting color cells - Forum - Excel
- Excel vba conditional formatting formula multiple conditions ✓ - Forum - Excel
- Excel apply conditional formatting to entire column - Guide
- Excell 2013 - conditional formatting using a formula- apply rule ✓ - Forum - Office Software
- Excel formula conditional formatting if cell contains text ✓ - Forum - Excel
3 replies
venkat1926
Jan 13, 2010 at 09:23 PM
- Posts
- 1864
- Registration date
- Sunday June 14, 2009
- Status
- Contributor
- Last seen
- August 7, 2021
Jan 13, 2010 at 09:23 PM
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.
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
venkat1926
Jan 14, 2010 at 08:23 PM
- Posts
- 1864
- Registration date
- Sunday June 14, 2009
- Status
- Contributor
- Last seen
- August 7, 2021
Jan 14, 2010 at 08:23 PM
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.
so it comes alright.
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.