highlight records on experation date( Excel 2003)

M

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
 
G

Gary Brown

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