Hi:
I am trying to create a Macro for the following:

I have a spreadsheet wherein Cell C3 to Q3, I have weekdays (Mon, Tues,
Wed, Thurs, Fri, Sat, Sun). The value of this range is populated based
on formula on another range of cells.

Based on the above weekday value(ex: Sat, Sun or Mon), I want few other
cell ranges to be shaded with a specific color unique to the weekday
value.

Any help with code is greatly appreciated

thanks
Shiv