What excel formula highlighs cells according to current date

[Guest]

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.

 

[Guest]

You can use Conditional Formatting. See:


http://www.contextures.com/xlCondFormat01.html

 

[Guest]

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