Conditional highlighting based on comparison to business targets

pandyav

New member
Joined
Apr 22, 2015
Messages
10
Reaction score
0
Points
0
Hello,
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.

Thanks!
 

Attachments

  • Book2.xlsx
    13.1 KB · Views: 14
Back
Top