index/match and preserve color of the cells

[gledister]

Imagine we have 2 different sheets with datas and we are efficiently using the properties of the index/match function...

What we need to have at the end is to PRESERVE the color of the cells(the indexed ones - first sheet) at the second sheet where we are using the index/match formula...

any idea?!

Kind regards.

P.S: If something is not clear please ask me any question to make the problem clearer.

 

[Andrew Poulsom]

It's not possible for a formula to change the colour of a cell. You could use Conditional Formatting and apply the same condition to both cells.

 

[gledister]

Hi,

the colour of the cells(first sheet) is not given through by conditional formatting but its done manually for different reasons...

So the problem is to index match in the second sheet including the colour of the cells(manually given)...

Any idea?!

Kind regards.

 

[gledister]

*bump*

 

[gledister]

*bump*

If anyone have any idea, it would be precious.

Regards.

 

[Andrew Poulsom]

I told you it's not possible.

 

[gledister]

I c.

Thank you.

Regards.