excel 2003 How do I set up a formula to flag up a future expiry date of say 60 days
T Terrano2 Oct 21, 2004 #1 excel 2003 How do I set up a formula to flag up a future expiry date of say 60 days
B Bob Phillips Oct 21, 2004 #2 Conditional formatting. Select the cells, say A1:A10 Menu Format>Conditional Formatting Change Condition1 to Formula Is Add a formula of =A1=TODAY()+60 Select the pattern tab, choose a colour exit out
Conditional formatting. Select the cells, say A1:A10 Menu Format>Conditional Formatting Change Condition1 to Formula Is Add a formula of =A1=TODAY()+60 Select the pattern tab, choose a colour exit out
