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: 10
Default How to change text/font colour, using formula

Dear All,

Case 1:
A1 + B1 = C1
Condition, if A1 + B1 50, result must be in red color, ex= 51 (with red
color)
If A1 + B 1 < 50, result must be in blue color, ex= 49 (with blue color).
In MS Excell, could it happen? Using a formula in ms Excell? Not change
manually....

Thanks in advance...
Maul
 
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
I have my IF formula, how can i change the text colour for eachif??!! help please!! [email protected] Excel Worksheet Functions 2 April 24th 08 01:23 PM
formula to change font or cell colour Dave Excel Worksheet Functions 3 November 25th 07 08:25 PM
Change font colour for whole row Saleee Excel Worksheet Functions 2 October 10th 06 06:41 PM
Change Font Colour Automatic When Formula Match stevembe Excel Discussion (Misc queries) 3 October 3rd 05 11:45 AM
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 11:53 AM.

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

About Us

"It's about Microsoft Excel"