| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Highlighting dates in a cell relative to the TODAY()
I have a table with dates and wish to show:-
1. The date IF it has pasted requires to be highlighted in RED colour; 2. The date IF it is between 1 and 30 days from today's date to be coloured BLUE; 3. The date IF it is between 30 and 60 days from today's date to be coloured GREEN; By highlighting means that the text colour changes to the colour mentioned above and the font changes to BOLD. Many thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do count a cell range that include all dates prior to today? | Excel Discussion (Misc queries) | |||
| Count Dates <Today? | Excel Discussion (Misc queries) | |||
| Counting dates before today | Excel Discussion (Misc queries) | |||
| relative highlighting | Excel Discussion (Misc queries) | |||
| Counting Dates less then today | Excel Worksheet Functions | |||
![Steve HKG[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
