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.