Conditional formatting, based on a different cell?
 

Is it possible to use conditional formatting on one cell, based on the value
or conditions in another cell? In other words, if I wanted the cells in
column A to have a yellow fill color for every row that has a value of 1 in
column B, what kind of formula would I use in conditional formatting to
accomplish this?

Any help? Thanks!
--
GD

Conditional formatting, based on a different cell?
 

Select column A and enter =B1=1 in CF formula field! Choose yellow pattern!

Regards,
Stefi

€žGD€� ezt Ã*rta:

Is it possible to use conditional formatting on one cell, based on the value
or conditions in another cell? In other words, if I wanted the cells in
column A to have a yellow fill color for every row that has a value of 1 in
column B, what kind of formula would I use in conditional formatting to
accomplish this?

Any help? Thanks!
--
GD

Conditional formatting, based on a different cell?
 

Highlight the cells that you want this to apply to, eg from A2 to A20,
then click on Format | Conditional Formatting. Choose Formula Is in
the first box rather than Cell Value Is, and enter this formula:

=B2=1

Then click the Format button, choose the Patterns tab (for background
colour) and click on yellow. Click OK twice to exit the dialogue
boxes, then all those cells will have the CF applied and Excel will
have adjusted the references for each row.

Hope this helps.

Pete

On Feb 9, 2:20*pm, GD wrote:
Is it possible to use conditional formatting on one cell, based on the value
or conditions in another cell? *In other words, if I wanted the cells in
column A to have a yellow fill color for every row that has a value of 1 in
column B, what kind of formula would I use in conditional formatting to
accomplish this?

Any help? *Thanks!
--
GD

Conditional formatting, based on a different cell?
 

Select all the A cells to have this CF. I will assume the first one is A2
Use -- Formula Is =B2=1 and set the formatting as needed
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"GD" wrote in message
...
Is it possible to use conditional formatting on one cell, based on the
value
or conditions in another cell? In other words, if I wanted the cells in
column A to have a yellow fill color for every row that has a value of 1
in
column B, what kind of formula would I use in conditional formatting to
accomplish this?

Any help? Thanks!
--
GD