Conditional Formatting Question

M

markstro

Using Excel 2000, can I conditionally format a row to change
background color when the first column meets the condition of the
current date (within a 7 day range)
I would like the color to default to white unless the condition is
met, then the row be highlighted to show the current weeks row.
Hope I explained this well enough.
Mark Strohmeyer
 
J

Jonathan Cooper

Seems possible, but I think you will have to provide an example. I'm confused by what "within a 7 day range" means. Do you mean, 'if the date in column A is between today and 7 days from now'?

If I'm guessing correctly, highlight all of the cells that will potentially change color and go to conditional formats. change to 'Formula Is':
=IF(AND($A1>=TODAY(),$A1<=TODAY()+6),TRUE,FALSE)
 
M

markstro

Yes you guessed correctly, it works, thanks

Jonathan Cooper said:
Seems possible, but I think you will have to provide an example. I'm confused by what "within a 7 day range" means. Do you mean, 'if the date in column A is between today and 7 days from now'?

If I'm guessing correctly, highlight all of the cells that will potentially change color and go to conditional formats. change to 'Formula Is':
=IF(AND($A1>=TODAY(),$A1<=TODAY()+6),TRUE,FALSE)
Click to expand...
 
Top