Forum Discussion
Creating an baseline Assessment
OK, we need to back up here. With these percentage figures coming into the picture you are adding to the situation you first described. So could I ask you to start from scratch and explain what you're doing more fully. It's sounding now like you may have a person self-assessing on multiple skills (which wasn't explicit in your starting post).... So in that case, you're looking for a summary of multiple skills for each individual person, rather than the summary I gave you which is more of a summary of a single skill but multiple persons.
Could you post an image of your existing spreadsheet, the one you have developed. Or describe it more fully. Or post it in Google Sheets or OneDrive and give us the link to access it.
Here's what I think you're looking for. Now I see that it's one person, multiple competencies, multiple levels. (But I don't see any reference anywhere to those percentages.)
To see what's involved look at the Conditional Formatting dialog box, accessed two ways. Either from the Home tool bar, or the Format menu as shown below.
Select Conditional Formatting to see this:
mathetes : This is what I have been looking for. Just struggling to implement on my sheet. Thanks a million you are a genius. I now need to add one more condition to the drop-down of selections (Y, O, N, and a blank).
- If it's left blank (i.e., no response) then the conditional formatting leaves the cell white (or whatever you have set as default, normally white)....so you don't need to add a "blank" to the drop down.