Can I conditionally format 1 cell to look at 5 cells

DFRESH · Feb 19, 2009

I am trying to have 1 cell look at 5 cells and change color if any one of the
5 matches the 1 cell

Luke M · Feb 19, 2009

Assume the 5 cells are B1:B5, and A1 is the formatted cell:
=COUNTIF(B1:B5,A1)>0

David Biddulph · Feb 19, 2009

CF/ Formula Is:
=OR(A1=F1,B1=F1,C1=F1,D1=F1,E1=F1)