if statement format cell

J

Jane

Can I use an IF statement (or anything else) so that the answer to a question
in one cell dtermines the colout of ANOTHER cell?
 
S

Stefi

Yes! See Conditional formatting in Help (formula option) or give more details
on what do you want to do!

Regards,
Stefi


„Jane†ezt írta:
 
A

Ardus Petus

You must use conditional formatting on the "OTHER" cell, with a formula
which refers to your original cell.

HTH
 
Top