Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formating to highlight dates 30, 60, and 90 days out? | Excel Worksheet Functions | |||
How can i make excel to highlight today using conditional formating | Excel Worksheet Functions | |||
Highlight Search Results | Excel Discussion (Misc queries) | |||
Highlight FIND Results | Excel Discussion (Misc queries) | |||
How would I set formating to highlight overscheduled days in a row? | Excel Discussion (Misc queries) |