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.

You can use Conditional Formatting. See:


http://www.contextures.com/xlCondFormat01.html
--
Gary's Student


"Al" wrote:

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.

I'd use conditional formatting (on the Format menu) You need the Formula Is
option and then set the condition to =A2NOW()-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

"Al" wrote:

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.