But for conditions like 'highlight top 10', it causes undesired results. Typically for condition like the one above, it may not matter, if the rules are split into multiple ranges. 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 |