highlight records on experation date( Excel 2003)

[micky57]

I would like to create a spreasheet to control document numbers by experation
date. When experation date comes up, the records involved should be
highlighteColor).


Any ideas would be highly appreciated.

Regards

micky57

 

[Gary Brown]

Used Conditional Formatting.
Use 'Formula Is' with a formula something like...
=$C1<=INT(NOW())
where column C contains the expirations dates.