troubleshooting Question

Coloring based in line B3:G3 items

Avatar of Pedro
Pedro asked on
Microsoft ExcelMicrosoft ApplicationsVB Script
21 Comments1 Solution298 ViewsLast Modified:
The idea here is to color all of the items following line 3 using the same color as the item itself. For instance, B31=31, thus any time the number 31 is found below  it is colored the same as it. NOTE: a different color is used for the value in C3 another for D3 another for E3 and F3 and G3.

I would like to be able to do the following:

1) coloring is done based on the numbers in B3:G3.
2) The script should prompt me or let me choose a range on numbers so that
          a) if B3:F40 are chosen then the number in G3 remains with no color.
           b) only the numbers in the chosen cells are colored.
3) if B3:G3 are blank then all of the chosen cells are returned to their original white background and black lettering. This allows me to 'reset' the page. Unless, of course if you have a better idea then by all means use it.
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 21 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 21 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros