Ask Your Question

Can Conditional Formatting be applied in all sheets? [closed]

asked 2014-06-30 20:01:46 +0100

Bonbonbillo gravatar image

Can Conditional Formatting be applied in all sheets, not only one sheet?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-27 10:45:30.990711

2 Answers

Sort by » oldest newest most voted

answered 2014-06-30 20:13:10 +0100

Lupp gravatar image

Only for every sheet in the same way. Conditionally formatted ranges belong to only the one sheet they were defined in. If there is used a formula it may, however, refer to other sheets, too.

(The present 'CF-Manage' dialogue allows for entering ranges of "cuboid" type. These aren't recognized anyway.)

edit flag offensive delete link more


This limitation is a deliberate decision:

Hynerian gravatar imageHynerian ( 2018-03-11 13:46:43 +0100 )edit

Yes, but that concerns the range of conditional formats manageable from one sheet. References into other sheets for a comdition of the 'Formula Is' type are allowed.
My remark concerning "the present CF-manager" was valid on 2014-06-30 and pointed out a little inconsistency. As I just tested the inconsistency still exists (without doing any harm except to my soul).

Lupp gravatar imageLupp ( 2018-03-11 14:52:19 +0100 )edit

answered 2014-07-01 09:36:50 +0100

Bonbonbillo gravatar image

Hope this function could be added in future version.So we don´t have to copy same conditioning formatting for each sheet.

edit flag offensive delete link more


1) Conditional formatting as we presently have it seems to be half-baked at best. As long as it doesn't reliably work with the given set of features improvement with this respect should be in the focus. About additional features later.

2) If you have many sheets and make extensive use of CF: How shall the manager provide access to all the ranges and how will you edit them correctly as long as the collection of equally CFfed parts is as inadequate as it is?

Lupp gravatar imageLupp ( 2014-07-01 11:13:04 +0100 )edit

Question Tools



Asked: 2014-06-30 20:01:46 +0100

Seen: 779 times

Last updated: Jul 01 '14