Home |
Search |
Today's Posts |
#1
|
|||
|
|||
colors
Can anyone help me with colors using IF statement.
Column A and Column B has numbers and Column C is a logical field to display thumps up or thumps down with colr green or red. I have Thumps Up symbol and Thumps Down Symbol from wingdings font. If number in Column A is greater it should turn the thumps up sign green in color and if number in Column A is smaller the color of ThumpsDown symbol should change to red (defualt color is black and default thumps direction is up) |
#2
|
|||
|
|||
Use conditional formatting: Format-Conditional Formatting.
Choose "formula is" and enter this formula for condition 1: =if(A1B1,TRUE,FALSE) Then, for the formatting make the font green and do whatever else you wish to occur if column A is greater than B. Likewise make this formula for condition 2: =if(B1A1,TRUE,FALSE) and make this formatting Red color. -- Regards, David Billigmeier "Mir Khan" wrote: Can anyone help me with colors using IF statement. Column A and Column B has numbers and Column C is a logical field to display thumps up or thumps down with colr green or red. I have Thumps Up symbol and Thumps Down Symbol from wingdings font. If number in Column A is greater it should turn the thumps up sign green in color and if number in Column A is smaller the color of ThumpsDown symbol should change to red (defualt color is black and default thumps direction is up) |
#3
|
|||
|
|||
Dave's response is just what you need. I would like to ask what you intend to do if A1=B1? You may want to address this as such: =IF(A1B1,"C",IF(B1A1,"D","K")) formatted as WingDings (the "K" returns the smilely face with no expression). Following Dave's Cond. Formatting, this would be returned in the Automatic font/fill color. HTH Bruce -- swatsp0p ------------------------------------------------------------------------ swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101 View this thread: http://www.excelforum.com/showthread...hreadid=395839 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel reset colors does not work. | Excel Discussion (Misc queries) | |||
custom cell pattern colors | Excel Worksheet Functions | |||
How to add fill colors (cell shading) in EXCEL? | Excel Discussion (Misc queries) | |||
Colors and printing | Excel Worksheet Functions | |||
How do I get custom colors for filling cells in Excel? | New Users to Excel |