It depends upon how the data is laid out. Without that information, we are
just guessing.

--

HTH

Bob

"MikeD" wrote in message
...
I have 4 employees inspecting properties based on zip codes. Each employee
has multiple zipcode assigned to them (as few as 4 and as many as 12).
How
do I take a spreadsheet and write a single formula or use conditional
formating to find all of the zip codes assigned to an employee and change
the
row of infomation to match a single color assigned to the employee?