Date Highlight

[Guest]

Hi there,

I'm trying to set a warning so that when a product warranty is 90 days or
less away the cell is highlighted. I'd ideally like this then to go through
warning states on conditional formating i.e. 90-120 days amber, red if under
90 etc.

The information is currently entered as the day the warranty started but
could include the expiry date instead.

I have the today's date formula set in the spreadsheet already and I've
tried a few ways to get this to work but I can't seem to get this without
having two columns of information?

Is it possible to do this within the one cell?

Thanks

Thanks

 

[Guest]

Hi

Have a read of this:
http://www.cpearson.com/excel/cformatting.htm

This should help you some way towards your answer. Post back with some more
information if you need to.

Hope this helps.
Andy.

 

[oldchippy]

Hi there,

I'm trying to set a warning so that when a product warranty is 90 day
or
less away the cell is highlighted. I'd ideally like this then to g
through
warning states on conditional formating i.e. 90-120 days amber, red i
under
90 etc.

The information is currently entered as the day the warranty starte
but
could include the expiry date instead.

I have the today's date formula set in the spreadsheet already an
I've
tried a few ways to get this to work but I can't seem to get thi
without
having two columns of information?

Is it possible to do this within the one cell?

Thanks

Thanks

Hi cosmeticbrainsurgery?

If you warranty start date is in A1, try conditional formatting

First condition, formula is =A1>TODAY()-90, format cell to red

Second condition, formula is =A1>TODAY()-120, format cell to orange

Is this what you are looking for?

oldchippy :