Link Cell backgroundcolor

[rneve]

Hi,

I make a "link" from own cell to the other with the following command:

=Januari!B12

So now I got the value from sheet Januari cell B12. But I also want to "copy" the backgroungcolor from that cell!

Is there a simple command/solution for this?

Thanks in advance

 

[xlbo]

nope - you need code. Colours in excel are entirely useless except for presentation purposes - there is no way to determine or otherwise manipulate colours via formulae. The closest you can get is conditional formatting but that can only return a max of 4 colours

Rgds, Geoff

"Having been erased. the document thjat you are seeking. Must now be retyped"

Please read FAQ222-2244 before you ask a question