The formula should be:

=A1<TODAY()+DATE(0,6,0)

Regards,
Per

"Per Jessen" skrev i meddelelsen
...
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