formatting cells

[spidermassi]

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

[swatsp0p]

Check out Format>Conditional 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: =Q10>Q2 and select formatting as desired (font color or Pattern fill color)

HTH

Bruce