How to mass highlight data

Hello! I have basic ability when it comes to Excel. I need to examine data that was transferred to a Pivot Table. In one column, there are many different categories under four character codes. In anot...