ExcelBanter - Highlight expiry date

ExcelBanter (https://www.excelbanter.com/)

- Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)

- - Highlight expiry date (https://www.excelbanter.com/setting-up-configuration-excel/223865-highlight-expiry-date.html)

Karray

Highlight expiry date

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

Per Jessen

Highlight expiry date

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

Per Jessen

Highlight expiry date

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

All times are GMT +1. The time now is 04:23 AM.