Home |
Search |
Today's Posts |
#1
|
|||
|
|||
formatting cells
hi everyone. here is my problem: if q10=text1 q2 color red if q10=text2 q2 color green if q 10=text3 q3 colro yellow any idea? thank you very much Spidermassi -- spidermassi ------------------------------------------------------------------------ spidermassi's Profile: http://www.excelforum.com/member.php...o&userid=25823 View this thread: http://www.excelforum.com/showthread...hreadid=392159 |
#2
|
|||
|
|||
Check out FormatConditional Formatting... You can set up to three parameters to set formatting. I don't understand your "q10=text1 q2" etc. as parameters, but the syntax would be similar to this: Formula Is: =Q10Q2 and select formatting as desired (font color or Pattern 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=392159 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditionial formatting for merged cells, function Len($A$4) | Excel Worksheet Functions | |||
How do I link a cells formatting from one worksheet to another? | Excel Worksheet Functions | |||
Excel should allow more options for formatting cells | Excel Worksheet Functions | |||
How to copy "edge" formatting to other cells. | Excel Discussion (Misc queries) | |||
Formatting Cells | Excel Discussion (Misc queries) |