Conditional formatting, based on a different cell?

  • Thread starter Thread starter GD
  • Start date Start date
G

GD

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!
 
Select column A and enter =B1=1 in CF formula field! Choose yellow pattern!

Regards,
Stefi

„GD†ezt írta:
 
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
 
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
 
Back
Top