Home |
Search |
Today's Posts |
#1
|
|||
|
|||
automatically highlight cells with expired dates?!
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 |
#2
|
|||
|
|||
You can do it with conditional formatting. Format: Conditional Formatting:
Cell Value is less than e.g. 7/31/05, Format: Patterns: pick the color you want. Apply this to your cells. You should be good to go. Only draw back is that you wil lneed to update this way of doing it as the date changes. "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 |
#3
|
|||
|
|||
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 |