Results 1 to 2 of 2
Thread: Date Conditional Formatting
2001-02-22, 15:33 #1SandyMGuest
Date Conditional Formatting
Everyday I have a spreadsheet imported from Dbase into Excel. In this sheet is a column "StartDate" that has a date I want to turn red, 3 days before TODAY. What is the correct formula, and how can the Dbase hold the formula for exporting? Or can a macro be created in Excel? Please reply to firstname.lastname@example.org. Thank you!
2001-02-22, 16:18 #2
- Join Date
- Dec 2000
- Salt Lake City, Utah, USA
- Thanked 5 Times in 5 Posts
Re: Date Conditional Formatting
Select the topmost cell to be formatted, select Format, Conditional, Formula Is, enter
in the box to the right, apply your formatting (font red, or fill red, or whatever), copy the format down the column as required.
(Take out the rounding if you want the format to apply exactly 72 hours prior to the present moment.)-John ... I float in liquid gardens