Doubling of Conditional Formatting when adding a row.

%3CLINGO-SUB%20id%3D%22lingo-sub-1852929%22%20slang%3D%22en-US%22%3EDoubling%20of%20Conditional%20Formatting%20when%20adding%20a%20row.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1852929%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Every%20One.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20the%20attached%20excel%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%203%20line%20items%20with%20a%20conditional%20formatting.%20(Table%201)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20have%20added%20(copied%20to%20next%20row)%20one%20more%20row%2C%20the%20conditional%20formatting%20is%20doubled.%26nbsp%3B%3C%2FP%3E%3CP%3E(Table%202)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECould%20anyone%20please%20help%20on%20this%20matter%20to%20avoid%20doubling%20of%20conditional%20formatting%20whenever%20adding%20new%20data%2C%20since%20I%20have%20working%20with%20huge%20data%20SQL%20Source%20and%20updating%20information%20in%20one%20data%20sheet%20itself.%26nbsp%3B%20Adding%20to%20it.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20creates%20multiple%20conditional%20format%20and%20consequently%20my%20excel%20get%20hanged%20due%20to%20large%20size%20of%20the%20file.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1852929%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1853042%22%20slang%3D%22en-US%22%3ERe%3A%20Doubling%20of%20Conditional%20Formatting%20when%20adding%20a%20row.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1853042%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F420510%22%20target%3D%22_blank%22%3E%40Sameer_Kuppanath_Sulta%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ETry%20to%20apply%20the%20rule%20to%20expanded%20range%20with%20some%20gap%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F231430iC780265105FA2AAB%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Contributor

Hi Every One.

 

In the attached excel, 

 

I have 3 line items with a conditional formatting. (Table 1)

 

When I have added (copied to next row) one more row, the conditional formatting is doubled. 

(Table 2)

 

Could anyone please help on this matter to avoid doubling of conditional formatting whenever adding new data, since I have working with huge data SQL Source and updating information in one data sheet itself.  Adding to it. 

 

It creates multiple conditional format and consequently my excel get hanged due to large size of the file. 

 

 

 

 

 

 

 

 

1 Reply
Highlighted

@Sameer_Kuppanath_Sulta 

Try to apply the rule to expanded range with some gap

image.png