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

HTH
--
AP

"Jane" a écrit dans le message de news:
...
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?