Excel Macro - Help!!!

A

Auditor

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
 
B

Bob Phillips

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

Just use a formula like

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to select rows based on dates 11
Sorting day names chronologically 5
copy named range & paste 2
Time Sheet End of Month 1
routine to convert to date format 2
Need Formula to Calculate Time/Overtime (2) 2
do not chart rows with no information 4
recognizing overtime while preparing a schedule 1

Top