If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Conditional Formatting Question
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 |
#3
|
|||
|
|||
Conditional Formatting Question
|
Thread Tools | |
Display Modes | |
|
|