Hi, I am trying to make a visual skills matrix spreadsheet. I have formatted the cells to display the 5 graduated black and white icons that show from an empty circle to a filled in circle. These are set from 0 experience, to 100 experience(using numbers as opposed to percent). This works fine. What I need is a way to get a green filled in circle displayed for those people that can train, so basically have more than "100". I can enter anything for this to happen, but cannot figure out how to do this. Does anyone have a solution for me? I can provide more information if this is not clear enough.
Thanks, Greg
Bookmarks