I have a named list that I would like any row in the pivot table that matches any on that list to highlight the entire row. Named list is titled "Not_Legitimate", the column for it to find any matches on is column B, and I would like B:D to conditionally format. Make sense? I can get it to highlight only the first cell in column B with matches, and would like to learn how to complete the whole row within the pivot table.