formatting cells

S

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
 
S

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
 
Top