My company repairs customer equipment. My company's software exports a report to excel. The report produced is a list of equipment by customers location. The customer information is included with the report. I want to first sort the equipment by zip code.
I want be able to assign/populate a tech for each piece of equipment. I then want to be have a maximum number of pieces of equipment a tech can be assigned. When a tech is at 5% under or over the max, the tech cell is green. When a tech is at 6-15% over the max, the tech cell is yellow. When a tech is at 16-20% over the max, the tech cell is red. When a tech is at over 21% the max, the tech cell is black with white letters. I should also be able to adjust the report so it list the tech as the header and list each customer & their equipment assigned.