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)
 
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.
 

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

Similar Threads

How to highlight cells if it passes a set date? 6
Highlight expiry date 2
Emailing formula results 1
please suggest a formula 2
conditional Reminder 2
Conditional Formatting!!! 4
traffic light formula 6
textbox font colour 2

Top