+ Reply to Thread
Results 1 to 2 of 2

Conditional Formatting / Identifying Differences Between Tabs...

  1. #1
    Registered User
    Join Date
    04-25-2018
    Location
    Miami, FL
    MS-Off Ver
    2013
    Posts
    11

    Conditional Formatting / Identifying Differences Between Tabs...

    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.
    Attached Files Attached Files

  2. #2
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: Conditional Formatting / Identifying Differences Between Tabs...

    for Default Jobs:
    =IFERROR(INDEX(Roster!$Q:$Q,AGGREGATE(15,6,ROW(Roster!$A$2:$A$526)/(TEXT($A2,"#####")=Roster!$F$2:$F$526)/($F2=Roster!$O$2:$O$526)/($E2=Roster!$N$2:$N$526),COUNTIFS($F$2:$F2,$F2,$E$2:$E2,$E2))),"")
    if i get it
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] conditional formatting identifying duplicates from another sheet.
    By arnoldsq in forum Excel General
    Replies: 5
    Last Post: 12-01-2017, 03:57 PM
  2. [SOLVED] Conditional Formatting based on percentage differences
    By Ady2673 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 12-28-2016, 02:07 PM
  3. Identifying Differences in Monthly Reports
    By nadrojylloh in forum Excel General
    Replies: 8
    Last Post: 07-28-2014, 06:57 PM
  4. Replies: 1
    Last Post: 04-12-2013, 04:16 AM
  5. Comparing two worksheets and identifying differences
    By sarahrose20 in forum Excel General
    Replies: 4
    Last Post: 07-24-2012, 08:26 AM
  6. Replies: 5
    Last Post: 07-18-2012, 01:55 AM
  7. Replies: 1
    Last Post: 11-15-2010, 12:24 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1