highlight records on experation date( Excel 2003)
 

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

highlight records on experation date( Excel 2003)
 

Used Conditional Formatting.
Use 'Formula Is' with a formula something like...
=$C1<=INT(NOW())
where column C contains the expirations dates.
--
Hope this helps.
Thanks in advance for your feedback.
Gary Brown


"micky57" wrote:

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