Hi all,
I work in a call center and I'm working on creating an Excel spreadsheet to collate stats.
I've got the basics worked out and I'm adding in some conditional formatting but I've run into a problem.
I have 2 sheets, one with stats where I want the colours to appear, and one with targets.
The targets change based on the skill level of a particular agent and there are different targets for each stat.
So, I need to have the stats in the table change depending on the skill level and type of stat from sheet 2.
So far I've come up with these formulas, but neither seem to work.
Can anyone help?
Stats.xlsxStats.xls
Bookmarks