Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formatting from Dates
Today's date will be manually entered in to a header cell.
The worksheet contains the dates that customers last purchased from me. How can I change the colour of the customer dates (and other details) eg. To Red if older than a year, to Green if less than a year? Apologies if this has a simple/obvious solution! Many thks, -- DavidM |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting with dates | Excel Discussion (Misc queries) | |||
Conditional Formatting-dates | Excel Worksheet Functions | |||
conditional formatting dates | Excel Discussion (Misc queries) | |||
Conditional Formatting (Dates) | Excel Discussion (Misc queries) | |||
Conditional Formatting with Dates | Excel Worksheet Functions |