LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Change font colour Min Excel Discussion (Misc queries) 9 February 18th 10 01:50 AM
Change font colour Stefi Excel Discussion (Misc queries) 1 March 28th 07 01:54 AM
Change font colour [email protected] Excel Discussion (Misc queries) 3 December 23rd 06 07:07 PM
Change font colour for whole row Saleee Excel Worksheet Functions 2 October 10th 06 06:41 PM
font colour change within a IF formula - Help!! Andyp Excel Worksheet Functions 2 August 25th 05 01:17 PM


All times are GMT +1. The time now is 12:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"