A little too vague I'm afraid...
1) Are the values you are searching for constants or formula results?
2) Are you search for a single word each time the macro will be executed or do you have a list of words? If a list, where i s this list at?
A list. I was just going to list of words in the macro.
3) To be clear, you want to search the entire workbook for the values, not just a single worksheet, right?
Correct. I have 5 sheets total. With info being shared across them all. So which ever is easier.
4) Can the value you are searching for exist more than once within the worksheet/workbook?
5) Do the values you are searching for occupy the entire cell they are in or can there be other text mixed in the cell with them?
Occupy the entire cell.
6) Are your merged cells physically merged on the worksheet (so that they look/act like a single cell)? Yes
Visio took a dump on me so I am using Plan B, and more reliable Excel to develop a floor plan for work. I have one floor per worksheet and I basically drew the floor layout. Each cube or office is represented by a square containg the seat number, followed by the occupants name and then name of the occupants manager. The data containing the names is derived from look ups on a separate tab in the work book. My first vision is for the seat number to be a color depending on what department that seat is assigned to. This is were is where I need to assign a list in point 2 above. OR another thought I just got is that the seat number color is derived from a look up of the department name from the data tab. My second vision is that the cell containing the occupants managers (based on the look up) gets colored. So if eg. manager is John Smith that cell showing John Smith would be blue. I would submit a screen shot but its a compliance thing......sorry I hope I didn't overload!