Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
1st need: Shading every other row. I have this figured out.
2nd Need: (this is where problems begin) I need to CF so that the date in the cell becomes red if it is 320 days old. I am using "cell value is, less than, =TODAY()-320" It works when it's alone, but when I use it WITH the 1st (above) CF, it only works for every other row. How can I combine these two to show BOTH every other row shaded and turn red if it is older than 320 days old. Thanks for the help. (I did search, I just couldn't find this particular issue) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
cond formatting | Excel Discussion (Misc queries) | |||
Cond Format - 7 conditions | Excel Discussion (Misc queries) | |||
cond formatting ? | Excel Worksheet Functions | |||
Cond formatting | Excel Discussion (Misc queries) | |||
Cond Formatting & Validation | Excel Discussion (Misc queries) |