Log In
Register
Home
Active Member
April 30, 2024
Offline
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.
Moderators
January 31, 2022
Offline
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.
1 Guest(s)
