SOLVED
Home

conditional formatting colos scale. duplicating format to independent rows

%3CLINGO-SUB%20id%3D%22lingo-sub-263722%22%20slang%3D%22en-US%22%3Econditional%20formatting%20colos%20scale.%20duplicating%20format%20to%20independent%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-263722%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20this%20need.%26nbsp%3B%20I%20need%20to%20conditional%20format%2C%20with%20color%20scales%2C%20thousands%20of%20rows%2C%20independent%20rows.%3C%2FP%3E%3CP%3Ein%20the%20attach%2C%20you%20can%20see%20in%20the%20left%20what%20I%20need%20as%20a%20result%2C%20but%20applying%20the%20conditional%20formatting%20and%20applying%20the%20format%20painter%20to%20the%20thousands%20of%20rows%2C%20takes%20the%20aggregated%20values%20to%20define%20the%20color%20scales.%26nbsp%3B%20I%20need%20to%20format%20paint%20each%20row%20individually%20to%20get%20the%20expected%20result.%3C%2FP%3E%3CP%3Eis%20there%20any%20way%20to%20do%20it%20without%20having%20each%20set%20of%20rows%20individually%3F%26nbsp%3B%20and%20having%201000s%20of%20cond%20formatting%20rules%3F%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3EGabriel%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-263722%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EColors%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EConditional%20Formatting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-263759%22%20slang%3D%22en-US%22%3ERe%3A%20conditional%20formatting%20colos%20scale.%20duplicating%20format%20to%20independent%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-263759%22%20slang%3D%22en-US%22%3EThanks%20Sergei!!!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-263744%22%20slang%3D%22en-US%22%3ERe%3A%20conditional%20formatting%20colos%20scale.%20duplicating%20format%20to%20independent%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-263744%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Gabriel%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat's%20with%20VBA%2C%20please%20check%20this%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fstackoverflow.com%2Fquestions%2F51991016%2Fexcel-conditional-colour-scale-for-multiple-rows%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fstackoverflow.com%2Fquestions%2F51991016%2Fexcel-conditional-colour-scale-for-multiple-rows%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Gabriel Gordon
New Contributor

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 Replies
Highlighted
Highlighted
Related Conversations
Is it possible for Edge to play HEVC (H265) MKV files ?
HotCakeX in Discussions on
2 Replies
Cell Validation - Drop Down Lists and Text Formatting
JenSmith in Excel on
1 Replies
A problem with the Zoom level of a Tab
Tavory in Discussions on
9 Replies
How to SUM Data from non-regular rows
Andy_Przybysz in Excel on
1 Replies