| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional formats for cells
Any chance of someone keying in a date prior to today's date, e.g. yesterday's date? If yes, do you want it green, red or something else?
Epinn "Jason Bartup" <Jason wrote in message ... I wish for certain cell to be say green if date entered is within one year of todays date. Then change to red if date is over one year of todays date. I know this is possible but cant get the right formular |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel: Having more than 3 conditional formats would be helpful. | Excel Worksheet Functions | |||
| Conditional formats don't print | Excel Discussion (Misc queries) | |||
| how can i set more than three conditional formats to xl worksheet | Excel Worksheet Functions | |||
| Paste Special Formats Generated by Conditional Formatting | Excel Discussion (Misc queries) | |||
| how do I apply more than 3 conditional formats in excel | Excel Discussion (Misc queries) | |||
Threaded Mode
