The code you have only runs if you make a change to the worksheet.

You could remove that requirement and make the code run on demand (maybe a
button to start it--maybe tools|macros|macro). But then it wouldn't be
automatic when you changed the data.

And you'd have to add some checks to make sure you're on the correct type of
data before you make the change.

JVANWORTH wrote:

Things are proceeding but slowly. Couple of questions.

I have a completed workbook that I manipulated as follows:

I have ten (10) worksheets that I use as sources:
English
Social Stud
Math
Science
Wrld Lang
PE Health
Special Ed
VPA
Career Ed
Misc

Sheet1, Sheet2, Sheet3 and Sheet4 are linked to all ten worksheets.

I pasted your modified code for source sheets into each of the ten (10)
source sheets (I added courses to the color sectiom)


Then I pasted your original code into sheets1234.

At first no cells changed colors. Then I clicked on a linked cell, hit
<enter and all the €˜ENG 9 GEN cells changed red€¦€¦€¦..as I did this with
each course. They would change to their designated color. My computer take
34 seconds to grind thru each change, but it works. When I change the
source€¦color changes€¦.very nice.

Do I need to go thru and click/<enter all the cells?

Other question:

We have three (3) different level of classes: General, College Prep and Gate
for each grade level: 9th, 10th, 11th, 12th.

Can I tweak Sheet1 so it only changes color for Freshmen General-red,
College Prep-blue and Gate-yellow classes, and so on€¦€¦.. Sheet2 for
Sophomore, Sheet3 for juniors and Sheet4 for seniors?

Right now I have Sheets234 changing the same colors for all grade all
levels€¦€¦..which it should do with your code