One way:

Select B1. Choose Format/Conditional Formatting...

CF1: Formula is =A110
Format1: Pattern/Red


will cause B1 to have a red background when A1 is 10.

In article ,
"esslinger" wrote:

Is it possible to format one cell dependent on the value
of a different cell?