# Brad from LI

#### Brad from LI

##### New Member
I have a 2010 excel spreadsheet. The column headings are:

 Level Number Day Dates Site Visitor Completed Fee V 123456 Wed 12-Mar-2014 Park Kids Y \$50 V 987654 Fri 21-Mar-2014 Stream Adults N \$75 V 698523 Wed 26-Mar-2014 Forest Adults N \$75 V 147852 Tue 8-Apr-2014 Stream Kids N \$50

<tbody>
</tbody>

There can be several more rows of same basic info.

What "Conditional Formating" formula would highlight all seven columns whereby the rows that are:
1) within the same week (Sun-Sat) as the current date, in one color
2) within the same week (Sun-Sat) as the week FOLLOWING current date, in another color
3) all other rows not within the above two parameters are clear

for example, using the spreadsheet above, if the current date were March 18, 2014:
row 1 would be clear (uncolored)
row 2 would be colored red (all seven columns within that row)
row 3 would be colored green (all seven columns within that row)
row 4 and beyond would be clear (uncolored)

### Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.
Select Row 2 then your conditional formating tool
then select Use a Formula to determine cells to format
place this formula into the "format values where this formula is true" box
=WEEKNUM(\$D2,1)=WEEKNUM(TODAY())
then format fill red
select new rule and place this formula into the "format values where this formula is true" box
=WEEKNUM(\$D2,1)=WEEKNUM(TODAY())+1
then format fill green
then apply
verify by changing D2 to yesterdays date then a date in next week it will change the row color accordingly

Replies
5
Views
260
Replies
7
Views
767
Replies
2
Views
928
Replies
11
Views
838
Replies
7
Views
967

Threads
1,221,309
Messages
6,159,164
Members
451,543
Latest member
cesymcox

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back