Conditional Formating Highlight Results
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? |
Conditional Formating Highlight Results
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? |
All times are GMT +1. The time now is 09:03 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com