| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting
I have a column (J) with due dates expanding to 2015. I would like the due
date to change color when: 1. Due date is within 15 day of today's date (Yellow). 2. Due date is pass today's date (Red) 3. Due date is out pass 365 days (No color) Can this be done? -- pls |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I convert conditional formatting into explicit formatting? | Excel Discussion (Misc queries) | |||
| Conditional formatting--different formatting depending on cell con | Excel Discussion (Misc queries) | |||
| Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| Conditional Formatting that will display conditional data | Excel Worksheet Functions | |||
Threaded Mode
