Highlight expiry date
 

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

Highlight expiry date
 

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

"Karray" wrote:

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

Highlight expiry date
 

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


"Sheeloo" wrote:

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

"Karray" wrote:

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

Highlight expiry date
 

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


"Sheeloo" wrote:

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

"Karray" wrote:

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

Highlight expiry date
 

Yes...
=(A1-TODAY())<180

Pl. check that their are no quotes in the formula...

"Karray" wrote:

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


"Sheeloo" wrote:

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

"Karray" wrote:

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