Excel Conditional Formatting based on Other Column

Question

I have two columns in Excel as shown on the picture below.

enter image description here

I need to apply conditional formatting in this way:

if row in B column contain "1", the cell A on the same row should change its color. This needs to be applied only for the cell in A column, not whole row. Is there any option how to do this?

CustomX · Accepted Answer · 2013-11-04 14:01:49Z

28

Follow these steps and your problem will be solved ;)

Set your formula to =$B2=1
Select the fill color Yellow
Applies to =$A$2:$A$7
Once you click Apply, make sure your formula hasn't changed! (always happens to me)

enter image description here

answered Nov 4, 2013 at 14:01

CustomX

10.2k30 gold badges89 silver badges115 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Excel Conditional Formatting based on Other Column

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related