Forum Discussion
danr1
Apr 11, 2022Copper Contributor
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 ...
danr1
Apr 11, 2022Copper Contributor
Hi,
Thanks for the reply, I've tried that but it doesn't work
Thanks for the reply, I've tried that but it doesn't work
SergeiBaklan
Apr 11, 2022Diamond Contributor
- danr1Apr 11, 2022Copper Contributor
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
- SergeiBaklanApr 11, 2022Diamond Contributor
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.
- danr1Apr 17, 2022Copper Contributor