| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
take a look at Conditional Formatting in XL Help.
Example: Assume A1 has an expiration date. Select A1 and choose Format/Conditional formatting... enter CF1: Cell Value is less than =TODAY() Format1: Patterns/<color In article , "cwest123456" wrote: i'm trying to automatically highlight cells in Excel with expired dates. is this possible? i cant figure out how to do it unless i do it by hand |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I combine the text from multiple cells automatically | Excel Worksheet Functions | |||
| automatically fill in a range of cells | Excel Discussion (Misc queries) | |||
| Cells no longer highlight when selected | Excel Discussion (Misc queries) | |||
| automatically PRINT only active cells? | Excel Discussion (Misc queries) | |||
| Sequential dates in different cells | Excel Worksheet Functions | |||
Hybrid Mode
