Highlight expiry date


K

Karray

Can anyone please tell me how to highlight a cell red when a date is within 6
months of expiry. (Excel 2003)
 
Ad

Advertisements

S

Sheeloo

To highlight cell A1 with expiry date in it, use Conditional Formatting with
FORMULA IS and use the formula
=(A1-Today())<180
and choose the format you want

You can paint this format over other cells you want to highlight
 
K

Karray

Thanks for replying Sheeloo - I have tried this and it didn't work. Is it
meant to be ())?
 
K

Karray

Sheeloo my apologies - my date wasn't formatted as "date" - once I did this
your suggestion worked - thank you very much.
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top