Results 1 to 1 of 1

Thread: Conditional highlighting based on comparison to business targets

  1. #1

    Conditional highlighting based on comparison to business targets

    Register for a FREE account, and/
    or Log in to avoid these ads!

    I have this spreadsheet where I am measuring efficiency of our operations department based on different criteria. I am attaching the spreadsheet to make things easier.

    What I want to achieve is:
    - For 'Avg Time to Ticket Closed' metric, compare Actual numbers in row 8 to monthly target in row 7 based on the month selected in C2 and highlight it in Green color if current month's actual is less than current month target and highlight it in Red if current month's actual is greater than target
    - For the same metric - 'Avg Time to Ticket Closed', compare YTD number in D7 to the YTD target based on the average of targets up to the month selected in cell C2. So, if March is selected in C2, YTD target will be the average of January, Feb and March targets. And compare this target to D7. If D7 is less than YTD target, highlight it in Green otherwise Red.

    Can this be achieved? I am truly struggling with this and will appreciate any help I can get.

    Attached Files Attached Files

Posting Permissions

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