CODEWITHSUNDEEP
excelconditional-formatting
DNac
DNac

Reputation: 2783

Excel Conditional Formatting based on Other Column

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?

Upvotes: 14

Views: 68885

Answers (1)

CustomX
CustomX

Reputation: 10113

Follow these steps and your problem will be solved ;)

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

enter image description here

enter image description here

Upvotes: 28

Related Questions