Help me with a specific colour conditional formatting please?

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 :slight_smile:

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