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