Brad from LI

[Brad from LI]

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)

 

[Latchmaker]

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