| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Format Help
I'm using Excel 07; I need to set conditional format based on dates. Row "C"
projects 4yrs 6months from "B"; I need each row to change colors based on: "C" is less then today's date ($C2<TODAY()); Today's date is within 6months of "C"; Today's date is within 90days of "C"; and today's date is within 30days of "C". I would appreicate any help. Thanks B C 2008 05 06 2012 11 06 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Capture conditional format as cell format | Excel Discussion (Misc queries) | |||
| New Conditional Format Overriding Previous Conditional Format | Excel Discussion (Misc queries) | |||
| How to create a conditional format that changes the number format | Excel Discussion (Misc queries) | |||
| Conditional Format - Format Transfer To Chart | Excel Discussion (Misc queries) | |||
| copy conditional format to regular format | Setting up and Configuration of Excel | |||
Threaded Mode
