conditional formatting colos scale. duplicating format to independent rows

[Gabriel Gordon]

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

[#2 · Accepted solution]

Hi Gabriel,

That's with VBA, please check this https://stackoverflow.com/questions/51991016/excel-conditional-colour-scale-for-multiple-rows

[#3]

Thanks Sergei!!!