Date Conditional format

[impala096]

How do i conditional format a column of dates so that every week it alternates colors.

Example. Week 1 data would be blue, Week 2 data would be red, Week 3 data would turn back to blue.

Thanks for any suggestions
Impala096

[daddylonglegs]

Can you explain a bit more. What dates do you have, are you showing a list of consecutive dates, for what period of time. What day does a new week start, Monday, Sunday?

[impala096]

I will be using it to track certain stocks throughout the course of a week. However, i won't have data present every day with some weeks being completely skipped in which i would want the color to still alternate.

I attached a spreadsheet that further details what i'm trying to accomplish.

[daddylonglegs]

For your example...select your dates B2:B11

and use conditional formatting with this formula for condition 1

=MOD(SUM(IF(FREQUENCY(B$2:B2-WEEKDAY(B$2:B2,3),ROW(INDIRECT(B$2&":"&B2)))>0,1)),2)

format as required

and for condition 2

=MOD(SUM(IF(FREQUENCY(B$2:B2-WEEKDAY(B$2:B2,3),ROW(INDIRECT(B$2&":"&B2)))>0,1)),2)=0

format as required

[impala096]

Hi there,

Thanks so much for your formula. It seems to work perfectly. No idea how you got it but it worked!