I have a column with values such as 00Q7000000JqHbA and 00Q7000000JqHba that are separate entries. When I go to Conditional Formatting > Highlight Cells Rules > Duplicate Values, these values get marked as duplicates when they're not for my purposes. Is there a way to make the filter case sensitive?

For example, the two entries "BLUE" and "BLUE" would be marked as duplicates, but the entries "RED" and "red" would not.