Project

General

Profile

Actions

Task #2429

closed

Inserting new rows makes conditional formatting rules complicated

Added by stewart carswell over 6 years ago. Updated over 5 years ago.

Status:
Rejected
Priority:
Normal
Assignee:
-
Category:
-
Target version:
-
Start date:
Due date:
% Done:

100%

Tags:

Description

If conditional formatting is applied across spreadsheet, then Inserting a new row above screws up the conditional formatting rules. See screenshot. Previously I had 4 rules for D4:ZY585. I then inserted a new row above row 86, and I now have 8 rules. The conditional formatting applies to the region I want it to, but it is messy, and it gets more complicated if I were to insert another new row.


Files

screenshot.png (64.1 KB) screenshot.png stewart carswell, 2017-12-03 11:28
Actions

Also available in: Atom PDF