Formatting Problem-Highlighting a cell when date has expired past current date

A

alancyoung

Hi, I'm currently trying to set up a sheet that highlights when
current certificate has expired. When a user enters a date in a cel
and as time passes, that date expires, I'd like to highlight the cel
and ideally make it automatically say the word expired instead of th
date. If anyone can help it would be greatly appreciated.

Thank
 
F

Frank Kabel

Hi
for highlighting the cell you can use conditional formating:
- select your cell
- goto 'Format - Conditional format'
- enter the formula (if A1 is your cell)
=A1>TODAY()
- choose your format

For changing the text automatically you'll need VBA but maybe the above
solution is sufficient for you?
 
Top