Project

General

Profile

Task #2429

Inserting new rows makes conditional formatting rules complicated

Added by stewart carswell 13 days ago.

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

0%

Estimated time:
Tags:
URL:

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.

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

Also available in: Atom PDF