Take the 2-minute tour ×  I have a sheet that I would like to
highlight cells that are equal to any of the values listed in
range of cells on another sheet. How do I do this?  Sheet 1
contains values I want to highlight in green any cell that
equals any value in Row A of sheet 2.  For example, column A is
I want to highlight any cell on sheet 1 that equals Apples,
Oranges, or Peaches.  share|improve this question add comment  1
Answer  up vote 1 down vote accepted  In Excel 2010 you can use
cells from other sheets in the conditional formats formula. In
earlier versions this is not possible.  To search if the value
is in a list use the CountIF function.  Conditional Format Rule
Dialog Box  share|improve this answer I don't want to count the
number of occurrences. I have edited my question to make it more
clear. (I hope) –  Larry Aug 9 '12 at 2:06 Have you tried it?
The conditional format is asking a true false question. Anything
other than 0 is true. If the count is greater than zero it will
correctly highli