I have a workbook where I want to color fill using conditional formatting if the cell in sheet DATA column D matches any of the values in sheet Data in list woodworking on sheet LISTS D4 to D9. The closest I found was using countif but that only formats the last cell if there are more than one. I want to format all that match.
You are on the right track but need to change one small reference. When you apply a conditional format to an entire column ($D:$D) the reference to the cell that requires formatting must point to the first one in the row. So change the first rule rule to this:
=COUNTIF(Dropdowns!$D$4:$D$9,$D1)>0
By the way, the 2nd and 4th rules seem to be the same but with different colors. The 3rd rule, I don't understand as the applied range is all over the place.
Thanks, I cleaned up the duplicate and other. I made the change you suggested. that took care of it.
Great! May I assume it works then?
