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

Sounds like a job for conditional formatting, no VBA needed.

Just use a formula like

=TEXT(A2,"ddd")=A$1

--
HTH

Bob Phillips

"Auditor" wrote in message
oups.com...
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