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