Good evening,

I have 4 cells with drop down lists on sheet 1.
On sheet 2, I have just the one cell with a drop down list.

I am trying to use conditional formatting so that if any one of the four cells on sheet 1 match the cell on sheet 2, the cell on sheet 2 turns amber. However, whenever I use =AND, it requires all 4 cells to match the single cell on sheet 2.

Is there any way around this?

Thanks!