Warnings
Hi,
You can make a conditional formatting on your date column and find the
result in color for example:
if the date is before expiry date no color
in expiry date the color could be yellow
after expiry date the color could be red
Thanks,
--
Farhad Hodjat
"Idoia" wrote:
if your date is in cell A1, put the following formula in cell B1:
=IF(A1-TODAY()<31,"Warning","OK")
Note that with this formula you'll get "Warning" also when certificates have
already expired. You could improve the process by having:
=IF(A1<TODAY(),"Expired",IF(A1-TODAY()<31,"Warning","OK"))
"Lynz" wrote:
I have an excel document with dates of when offshore certificates expire. I'd
like a column that would say "Warning" when it's 30 days before the
certificate expires, unitl a new date is entered then it would say "OK".
|