excel conditional formatting comparing different rows and columns

0
votes

I'd like to change background color of cells if the value of $E2=$F1 (comparing different row and column). The range I have selected is =$E:$F. I want the background color changed in both same value cells or at least on the first column cell. The problem is that I don't know of to tell excel to change the "1st. column, 2nd. row" of every comparison. Excel is changing only the cells of the first row and not the cells that have the same value.

Excel Sheet Formula

I don't speak English, I hope you can understand what I am saying. :-)

Thank you!!!

1
excel

1 Answers

0
votes

Create a custom formula rule as =$E1=$F1, and apply it to the range =$E:$F.

Be careful that this will see two blank cells as equals and turn them red, so you're better off doing =$E3=$F3 applied to the range =$E3:$F12.

EDIT

Now I understand your question, just create two different rules,

  1. =$E4=$F3 applied to range =$E4:$E12
  2. =$E4=$F3 applied to range =$F3:$F12