Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
writing a formula for a colored value | New Users to Excel | |||
Formula works in some cells, doesn't in other | New Users to Excel | |||
referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
Simplify formula | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |