Hi everyone
I have attached a workbook. It denotes the progress of people across a range of 4 levels (Starting, Developing, Reaching and Exceeding) over three Assessment points towards a target which is also one of these 4 levels. The workbook tries to show the progress of each person towards that target using the color key below each Point. I have given each level a numerical value, 10-40 to allow me to calculate progress using a simple percentage calculation to match the key. What i have though is level followed by calculation number followed by level followed by calculation etc and its a bit unwieldy....
What would be ideal is if I could remove the numbers from the cells and instead simply have the level in the box 'Starting' etc' in a color coded cell.
I know its extremely clunky but my Excel skills are practically non existent. Any kind help from any of you would be hugely appreciated especially in refining what i've done so far!!!!!!
Thank you so much
E
Bookmarks