What excel formula highlighs cells according to current date

A

Al

I would like to flag certain rows of information on an excel spreadsheet
according to current date. i.e. flag certain invoices 2 weeks before due
date. What formula can be used to acheive this?

Thanks.
 
S

Sheila D

I'd use conditional formatting (on the Format menu) You need the Formula Is
option and then set the condition to =A2>NOW()-14 (assuming your date is in
cell A2. Once you've got it to work you can use the Format Painter to copy
the formatting to the rest of the cells / columns
HTH - Sheila
 
Top