Ask Your Question

Conditional formatting ranges get massacred from editing/working with sheet

asked 2017-03-05 08:04:36 +0200

Nanshen gravatar image

updated 2017-03-05 08:07:37 +0200


My Calc sheet utilizes conditional formatting quite heavily and is also being continuously updated and expanded. After said updates and expansions, instead of having a few nicely defined range rules under "Conditional Formatting Rules", I'm left with tens of thousands of individual cell rules (one for D597, one for D598, one for D599, etc. etc. etc. -- utterly impossible to update or work with). Current solution is to wipe all rules and redefine from scratch... but that's quite a monotonous waste of time.

Save me?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2017-03-05 11:26:07 +0200

Lupp gravatar image

updated 2017-03-05 11:57:43 +0200

See bug report tdf#95295.

To avoid the problem as long as the bug is not fixed you may calculate the condition in a helper column and apply dedicated cell styles with the help of the STYLE function. However, this is only applicable with formula results, and it does not just overlay style properties but actually assign the different cell style to the cells concerned.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-03-05 08:04:36 +0200

Seen: 71 times

Last updated: Mar 05 '17