I have a list of first column is Employee Id Numbers, Second column is Dates of checks issued. I want to find if there are any duplicate dates for a single employee ID number. I thought if I filtered the ID number and put a conditional value for Duplicates on dates I would be able to quickly see if any of the dates were the same. However since the conditional value is reading all the dates outside the filter everything is Highlighted. Is there anyway to get the conditional value to apply only to dates shown?