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

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