Can I conditionally format 1 cell to look at 5 cells
 

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

Can I conditionally format 1 cell to look at 5 cells
 

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

Luke M
*Remember to click "yes" if this post helped you!*


"DFRESH" wrote:

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

Can I conditionally format 1 cell to look at 5 cells
 

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

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