Removing the number from the cell and leaving just the colour

[leemc1985]

Hi All,

This maybe a simple one, but i just cant work it out.

I have set up a formula to turn a cell red or green based on the number calculated! What i want to do now is remove the number calculated and just leave the colour within the cell.

Any ideas??

Many thanks..

[kersplash]

You could set the font colour to match the fill colour.