Results 1 to 2 of 2
Thread: conditional formatting
2001-02-14, 17:52 #1SandyMGuest
I'm opening a .dbf file in Excel 2000 and want to apply conditional formatting to one column. My column is "SchedDate" which I want to turn red 24 hours before that date is reached.
2001-02-14, 18:01 #2
- Join Date
- Dec 2000
- Burwash, East Sussex, United Kingdom
- Thanked 193 Times in 179 Posts
Re: conditional formatting
You didn't say whether you wanted to do this in code so I assumed you wanted the manual version.
Highlight the column, select Format-Conditional Formatting and use Formula Is =TODAY()-A1=1
Hope that helps.Regards,
Microsoft MVP - Excel