Hi

You have to use conditional formatting.

With the date in A1 goto Format Conditional Formatting Condition 1:
Formula is Enter this formula in the empty field: =A1<TODAY()+DATE(0;6;0)

Format as desired OK OK

Hopes this helps

---
Per

"Karray" skrev i meddelelsen
...
Can anyone please tell me how to highlight a cell red if the expiry date
entered is within 6 months of expiring.
--
Kaz