Ask Your Question

Help me with a specific colour conditional formatting please? [closed]

asked 2013-09-24 17:46:41 +0200

Tom@uni gravatar image

I would like to implement a conditional formatting such that if the colour of a particular cell (e.g. A1) is red, then other cells (e.g. B1, C1 and D1) will become red as well, thanks for any feedback to my problemo :)

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-10 00:09:27.575703

1 Answer

Sort by » oldest newest most voted

answered 2013-09-24 22:18:12 +0200

m.a.riosv gravatar image

There not defined functions to get the cell colour.

But it is possible define one. In this thread of Aoo forum you can find the macro for a function to get it between others, developed by Andreas Seager, look for the function CELL_BACKCOLOR.

Introspective functions

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2013-09-24 17:46:41 +0200

Seen: 174 times

Last updated: Sep 24 '13