Formula Color

[Foxtrot]

Hi, i need a formula to colour code calculated figures, ie say the calculations are in Col-C and Rows-1to10 - if the calculated number is "0" then it must be "green", if the number is lest than "5" then it must be ""blue" and if it is more than "5" then it must be red. Thanks for the help...

 

[ADAMC]

Probably do this using conditional formatting....

what version of excel are you running?

To clarify:

data is in C1 - C10

0 = green
< 5 = blue
> 5 = red


Cheers