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