Dynamic Highlighting in Excel
Find cells containing specific text A customer called me today to ask a question about Excel. I thought it was an interesting challenge, so I’ll share it with you here. The customer has a list of part numbers and their components. When they select a component part number, they want to quickly find all parent part numbers that contain that component. The parent part number is in column A, and the component part number is in column B. Here’s an example: Notice that the parent p