Conditional Formatting Question

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

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)



"markstro" wrote:

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

Yes you guessed correctly, it works, thanks

Jonathan Cooper Jonathan wrote in message ...
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)



"markstro" wrote:

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