Your question appears easy to answer, unfortunately, it is difficult to
assertain just what you are trying to ask or do.

Your message states, "the value there should be 5" ... but does NOT define
what "there" is!

Please clarify your needs and I'm sure we'll be able to help you out.

"natasha90" wrote:

CAN ANYONE HELP ME!!!!

I need to change the colour of the font when a value is greater or less than

for example;

the value there should be is 5,

if the value is 4 then the text should say (order now) in red font,

which i have managed to achieve using the following formula;

=IF(B8C8,"ORDER NOW!!")

the problem is....

if the value is more than 5 the text displays FALSE, although the writing is
still in red, and i cant find a formula that will let me change this!!!


If anyone can help it would be much appreciated

Thankyou

Natasha