Conditional Formatting Question

  • Thread starter Thread starter markstro
  • Start date Start date
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
 
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)
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Alternate Row Coloring 6
Conditional Format 1
Conditional Formatting help 4
COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2
help with IF cell meets certain condition..then do the following 3
Conditional Format 2
Conditional Formatting Applied when Statement Not True 6
Sorting Cells with Conditional Formats 1

Back
Top