Forum Discussion

Copper Contributor

Apr 11, 2022

Condiftional Formatting - New Row

Hi, Not sure where the best place to put this request but basically I have a few rules on Conditional Formatting that I would still like to be in place when making a new line. However when I put a ...

excel

Formulas and Functions

Macros and VBA

SergeiBaklan

Diamond Contributor

Apr 11, 2022

danr1

You may apply the rule to entire range with some gap, e.g. to A1:F1000

danr1
Copper Contributor
Apr 11, 2022
Hi,
Thanks for the reply, I've tried that but it doesn't work
- SergeiBaklan
  Diamond Contributor
  Apr 11, 2022
  danr1
  
  Like this?
  - danr1
    Copper Contributor
    Apr 11, 2022
    SergeiBaklan Hey,
    
    Yeah, mine looks the same but when I insert a new row it doesn't colour.
    
    The way i'm inserting a new row is done through a Macro, could this be why?
    
    Thanks