Cond. formatting, based on other cell values?
 

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

Cond. formatting, based on other cell values?
 

If you enter a value in A1 and want to color B1 if A1=1 then select B1,
choose CF and choose FORMULA IS option of conditional formatting and enter
the formula
as =A1=1

You can also color the whole row or range also based on value in A1...
Just select the cells
and use the formula
=$A1=1



"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

Cond. formatting, based on other cell values?
 

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

Cond. formatting, based on other cell values?
 

yes,

Assumed in Cell A1 you entered value 1 then Cell B1 to filled with
yellow color ?

if yes, then select the cell B1 and go to format | conditional
formatting | condition1:formula is =A1=1 | choose color | ok



On Feb 8, 12:15*am, 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