K
Karray
Can anyone please tell me how to highlight a cell red when a date is within 6
months of expiry. (Excel 2003)
months of expiry. (Excel 2003)
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
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
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 ())?
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.
your suggestion worked - thank you very much.
S
Sheeloo
Yes...
=(A1-TODAY())<180
Pl. check that their are no quotes in the formula...
=(A1-TODAY())<180
Pl. check that their are no quotes in the formula...