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
  - SergeiBaklan
    Diamond Contributor
    Apr 11, 2022
    danr1
    
    Let say you have data in D1:J10. You apply conditional formatting rule to D1:J999. If you add new data in row 11, conditional formatting rule is already applied to it. That works till row #999. If one day you have more data just expand your range within the rule.