Forum Discussion
conditional formatting colos scale. duplicating format to independent rows
I have this need. I need to conditional format, with color scales, thousands of rows, independent rows.
in the attach, you can see in the left what I need as a result, but applying the conditional formatting and applying the format painter to the thousands of rows, takes the aggregated values to define the color scales. I need to format paint each row individually to get the expected result.
is there any way to do it without having each set of rows individually? and having 1000s of cond formatting rules?
Thanks,
Gabriel
Hi Gabriel,
That's with VBA, please check this https://stackoverflow.com/questions/51991016/excel-conditional-colour-scale-for-multiple-rows
Hi Gabriel,
That's with VBA, please check this https://stackoverflow.com/questions/51991016/excel-conditional-colour-scale-for-multiple-rows
- Gabriel GordonCopper ContributorThanks Sergei!!!