Ask Your Question

Possible to check if cell has background color?

asked 2020-03-24 07:52:25 +0100

zf gravatar image

This is a continuation of attempting to override background colors set by conditional formatting and potentially an XY problem. Basically, it doesn't seem like there's a built-in function to check whether a cell has a background color set (the first condition to check). If so, prevent it from being changed by conditional formatting of alternating row colors (the second condition); otherwise, apply row alternating colors on the no-fill background color.

In the example on that thread, the condition being checked is whether the cell has the value of a number. However, the data on my cell is arbitrary.

How would one create the first condition to check whether background color is set in order to short circuit the second condition if the background color is indeed set? As a last resort, would it be possible to give cells with a background color a user-defined attribute that can be checked for in the first condition?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2020-03-24 22:06:56 +0100

m.a.riosv gravatar image

Please take a look to this thread Calc sum cells values having some background color

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-03-24 07:52:25 +0100

Seen: 240 times

Last updated: Mar 24 '20