Open up B1 conditional format and use

Condition1: Formula Is: =A1=1
....and set the yellow color.

--
"Actually, I *am* a rocket scientist." -- JB

Your feedback is appreciated, click YES if this post helped you.


"GD" wrote:

Is it possible to conditional format a cell based on another cell's value?
Let's say I enter 1 in a given cell, and I want the cell to its immediate
right to be formatted with a yellow fill color. If this can be done, can
somebody walk me through it?

Thanks!!
--
GD