I'm trying to create a roster tool in which I'm able to identify differences.
On the 'manager grail' tab, I have a list of duties assigned to a manager. On the 'roster' tab, I have a list of employees - in this list includes their managers. I want to identify differences from the 'manager grail' tab, to that listed on the 'roster' tab. If an employee on the 'roster' tab has a differing 'total' than that identified on the 'manager grail,' I'm hoping to illustrate this...highlighting the whole row or even if it's possible to have the employee's name pulled in a list on a separate tab.
I want to identify any differences involving the work schedule, mot group #, default labor levels, default jobs (HR) Full path, hourly pay, and standard hour fields based on the manager assignments.
I'm not sure how to accomplish this feat. Am I able to use conditional formatting to identify the differences - right now, I have a list of just one manager...if I have a list of 15, is conditional formatting able to accomplish this.
Quite frankly, I feel like I'm grasping at straws with this project and flailing aimlessly...any help/ideas/thoughts would be greatly appreciated...I don't know how to approach this.
Bookmarks