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