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

Email notifications without opening application 1
Extract data in rows (with line breaks) to form a table 0
please suggest a formula 2
How to highlight cells if it passes a set date? 7
Highlight expiry date 2
Emailing formula results 1
Conditional Formatting Conundrum 3
Subtracting months formula 5

Top