Color Code Cell Containing Date Based on Day of Week

[hvercillo]

Hello All,

I have a pretty basic Excel 2010 spreadsheet with columns containing text or dates (mm/dd/yyy format). I want a formula or conditional formatting that will color code cells containing dates based on which day of the week that date occured, i.e. 12/30/2013 is a Tuesday and dates occuring on Tuesdays should be blue, Monday dates red, etc. I could do this manually, but eventually manually color coding will be cumbersome and I would rather figure this out now!

I am new to this forum, but would greatly appreciate any and all help! Please let me know if clarification is needed!

-Heather

[popipipo]

=WEEKDAY($A1;2)=2

Put this formula in 'conditional formatting'

[hvercillo]

That is similar to formulas I have been trying. I've attached an example of the spreadsheet I am working with. Columns B through M need to have this color code formatting. Is the date format wrong?

Sample Tracking - example.xlsx

[popipipo]

=WEEKDAY(B3;2)=2

Try this one

[Ursul]

hvercillo change your formula to be Relative and not Absolute: =WEEKDAY(B$3,2)=3 ... Note it's B$3 not $B$3!! and your formatting will work. Cheers