Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Estyl
 
Posts: n/a
Default Use color in a IF formula

hi
i would like to change the color of my text, for different condition in a IF
formula. I know that it's posible but a just don't remember the syntax.
ex: =if(A1=100;(red)"To much";(green)"To low")

Thanks
  #2   Report Post  
Anne Troy
 
Posts: n/a
Default

No. But you can do conditional formatting that says if your cells says "too
much", to make it red.
Format--Conditional Format...
************
Anne Troy
www.OfficeArticles.com

"Estyl" wrote in message
...
hi
i would like to change the color of my text, for different condition in a
IF
formula. I know that it's posible but a just don't remember the syntax.
ex: =if(A1=100;(red)"To much";(green)"To low")

Thanks



Reply
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
writing a formula for a colored value aaronwexler New Users to Excel 11 September 1st 05 03:11 PM
Formula works in some cells, doesn't in other Wowbagger New Users to Excel 13 June 30th 05 03:21 PM
referencing named formula using INDIRECT function [email protected] Excel Worksheet Functions 19 May 11th 05 09:48 AM
Simplify formula Luke Excel Worksheet Functions 37 May 6th 05 07:21 AM
Match / Vlookup within an Array formula Hari Prasadh Excel Discussion (Misc queries) 3 February 3rd 05 04:37 PM


All times are GMT +1. The time now is 10:26 PM.

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"