View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
natasha90 natasha90 is offline
external usenet poster
 
Posts: 1
Default FONT COLOUR CHANGE

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