the 2 rules with range as $O$19,$O$21:$O$105 & $O$20 respectively, if I insert a new row at 20th row. The problem is - when I insert a row in excel, this formatting range splits and I get 2 formatting rules. The condition is 'if cell value is > 10', it is formatted with red color. I have a conditional format for a range for e.g. Is there any other way to stop conditional formatting from breaking after inserting row/s Using Offset or Indirect in 'Applies To' does not seem to work.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |