Greetings:

Is it possible to apply conditional formatting to a cell which is NOT the
cell being modified?

For example, if I enter a 5 in cell A1, can Excel change the background
color of cell B1 to yellow?

(I know this can be done with VBA, but I'm wondering if there is a way to do
it with conditional formatting.)

Feedback is appreciated. Thanks.