FONT COLOUR CHANGE

[natasha90]

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(B8>C8,"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

 

[ND Pard]

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.

 

[Peo Sjoblom]

Try

=IF(B8>C8,"ORDER NOW!!","")


--


Regards,


Peo Sjoblom

 

[Jan Bolluyt]

Two responses
Change the =IF(B8>C8,"ORDER NOW!!") TO
=IF(B8>C8,"ORDER NOW!!","") which leaves a blank if it is false,

to Change to a red box in Excel 2007
Click on cell C8 and on the home tab and conditional formatting
Click on "New Rule" then click on "Use a formula to determine which
cells to format"
in the format values box type in =B8>=C8

Then click on the format button and the fill tab. Click on the color you
want and click OK
OK again and then apply. If you conditions are met the box should change
colors.

Hope this helps.

Jan

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