Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I am trying to set up a worksheet for work. I would like to have some
conditional formatting. In the date worked column will be dates going back months if not years. I would like to set up color changes for dates that are 90, 120, 150 days older then the date at the time of opening the worksheet =now(). Dates that are less then 90 days will have no color. I am a fisherman and with this worksheet I could tell in a glance how long it had been since I last worked an area. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro To Change Cell Color When Value Changes | Excel Worksheet Functions | |||
How do I add a range by date over 90 days older than today | Excel Discussion (Misc queries) | |||
Extracting data from the current date | Excel Worksheet Functions | |||
extract date from the most current date | Excel Discussion (Misc queries) | |||
Identifying the Active Fill Color | Excel Discussion (Misc queries) |