K Karray Mar 11, 2009 #1 Can anyone please tell me how to highlight a cell red if the expiry date entered is within 6 months of expiring.
Can anyone please tell me how to highlight a cell red if the expiry date entered is within 6 months of expiring.
P Per Jessen Mar 11, 2009 #2 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
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
