Conditional Formatting - Applying color schemes to multiple columns

[Charlie Day]

Hello,

I have 10 columns of data, each column has different set of values(one column has values ranging from .01 - 10 and another column has values ranging from 10,000 - 50,000), right now I'm selecting each column individually and applying conditional formatting>Color Scales. Is there a way for us to apply color scales to all the columns?. Format Painter for all columns does not work since each column has different set of values and are not related to each other (when I do that its treating entire column with .01-10 as red and entire columns with 10,000 -50,000 as green). I want to apply conditional formatting color scales on each column. I've been searching on the internet for answers but I can;t find the exact solution. I also can;t fine the color scale as a format if I'm selecting the formula. Please help.

Thanks

 

[AlanSidman]

I suspect that you require a VBA solution. Upload a sample worksheet with a clear and succinct explanation of your "coloring" and we will attempt to provide you with a viable solution.

 

[Peter Bartholomew]

Sorry but I think you are doing exactly what needs to be done. It would be possible to automate the process using a VBA macro but that might simply replace a repetitive task with a longer code development task!

 

[Peter Bartholomew]

... a longer code development task!

OK, maybe not so long if you can find someone who is prepared to help and knows what they are doing !!!