u/AT_specialist

I am trying to strikethrough text in 1 cell (AC2) when that text is selected from a dropdown anywhere within a range (B4:W27). I can only get it to work when the dropdown is a single cell in the conditional formatting. I've tried other suggestions from Youtube but the range is what seems to throw it off.

So for "BW" in cell AC2, I want it to strikethrough no matter if "BW" is selected from a dropdown in B4 or Q15. Each of the dropdowns is a merged cell. Does that matter? Here's a link to the Sheet: Dropdown Sheet