Would be helpful if you posted a file with an example of what you have 8-10 records and a mocked up solution. In this manner, we will completely understand your vague request.
I am looking for a way, if I place a series of digits in C1, and it will locate that number in any order in the range of C8:C500. Example: Say I placed 0074 in Cell C1, then I want it to highlight every number in C8:C500 that has those digits in any order. Assuming these digits were in that range, It would highlight 0470, 0074, 7040, 0047, 7740, 7004, and 4007. This can be accomplished with conditional formatting i'm sure, I just don't know how to do it.