Excel Conditional Formatting based on Other Column

excel conditional-formatting
DNac picture DNac · Nov 4, 2013 · Viewed 68.4k times · Source

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?

Answer

CustomX picture CustomX · Nov 4, 2013

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

Related questions

Conditional Formatting (IF not empty)

How do I conditionally format a cell so if not blank it is grey? I tried to do 'not equal', but it didn't work. I am using Windows Office 2003 with Windows XP at work. I don't see the same feature …

Read More
Change the color of cells in one column when they don't match cells in another column

I want to check if the values in one column are the same as values in another column. Whenever the values are not the same, I would like to change the color of these cells. For example: Column I, Column …

Read More
Conditional Formatting using Excel VBA code

I have Range object called DistinationRange which contains reference to range B3:H63 I want to apply the following two conditional formatting rules using Excel VBA code dynamically. (Because the range would not be same all the time) If Cell …

Read More