Retrieve Cell Background Colour in a VLOOKUP Formula

[John Kenneth]

Hello.

I need to be able to pull in cell background colour from one sheet into another, along with any data included in that cell also.

I'm using the following formula, which successfully pulls in the data from one sheet to another:

=VLOOKUP(A2;$Tasks.A$2:AQ$50000;23;0)

However I have no idea what additional text I need to apply to the above formula, in order to retrieve the cell background colour also.

Any ideas guys?

Thanks!

[keme]

The cell coloring is not a part of cell content, and not directly available to Calc functions.

If the color is set by a conditional format, you can use a corresponding condition in the target cell.

There are solutions available by installing some plugin. I can't recall what it's called, but someone else will come to your rescue...

[John Kenneth]

Ok Keme, thanks for your help.

[Villeroy]

See this topic for an explanation and solution: viewtopic.php?f=20&t=42114&p=194229#p194229