Geek Answers Handbook

Excel conditional formatting based on another column

I have two columns in Excel, as shown in the image below.

enter image description here

I need to apply conditional formatting as follows:

if the row in column B contains "1", cell A in the same row should change its color. This should be applied only to the cell in column A, and not to the whole row. Is there any way how to do this?

+7
excel conditional-formatting
source share
1 answer

Follow these steps and your problem will be resolved;)

  • Set the formula =$B2=1
  • Choose fill color Yellow
  • Applies to =$A$2:$A$7
  • As soon as you click "Apply", make sure that your formula has not changed! (always with me)

enter image description here

enter image description here

+15
source share

More articles:


All Articles