| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Format to display text alert
I have a column of dates that are expiry dates of professional trainings. I
want the cells in the same column to display "Good" if the expiry is more than 120 days away and "Book" when it is 120 or less days away. Would help if the "Book" appeared in red. Please help. Thanks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Date Alert | Excel Discussion (Misc queries) | |||
| display a conditional format in a range from another column | Excel Discussion (Misc queries) | |||
| Conditional format if cell does not display a blank | Excel Worksheet Functions | |||
| Function to display day in text format | Excel Worksheet Functions | |||
| Display Format with Text & Formula | Excel Worksheet Functions | |||
Threaded Mode
