Forum Discussion

danr1's avatar
danr1
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
danr1's avatar
danr1
Copper Contributor
Apr 11, 2022
Hi,
Thanks for the reply, I've tried that but it doesn't work
  • danr1's avatar
    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's avatar
      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.

      • danr1's avatar
        danr1
        Copper Contributor
        Apr 17, 2022

        SergeiBaklan 

        Hi, 

         

        That’s exactly what I have done but it doesn’t seem to work

Resources