Cell Format Colour in Formula Result

[Greenshutters]

Hi I could do with some help with a formual result.

I have a formula that checks for a value in a range of cells and when it finds it writes the valiue.

The cells in the lookup range ihave a pattern colour. The formula correctly returns the text value but does not return the format colour.

Any help would be appreciated.
Thanks

Formula
=IF(K4=2,$O$4,IF(K4=1,$O$5,IF(K4=0,$O$6,IF(K4=-1,$O$7,IF(K4=-2,$O$8,IF(K4=-3,$O$8,ERROR))))))

The Range o4 - onn has values and is has Pattern colour

[Richard Schollar]

Hi

You can do this if the colors in the lookup range are a result of consitional formatting - in which case you simply need to apply the same CF to the formula cells.

If not, then you won't be able to do this via formula alone - you would need to write a VBA script to achieve the formula cells being the same color as the lookup value in the lookup range.

Richard