- Thank you received: 0
Show as icon not working
- james.me.robinson
- Topic Author
- Offline
Less
More
8 years 3 months ago - 8 years 3 months ago #6480
by james.me.robinson
Dear Bert,
I'm finishing off an overview sheet that averages scores across several tabs. I want the number to be represented by number icons so that it is easier to see at quick glance.
On the test mark book, it worked perfectly, but on the final version of the workbook, it doesn't seem to be working properly. It is showing 0 as an icon fine, but as soon as the number changes, the cell is empty.
I have attached the mark book. It is the APP sheet that I am looking at. The first set of columns is the average calculation column. The second set of columns is where I am trying to represent the number as an icon.
I have set up the icons as a grade so it should all work ok.
Would you be able to have a look and see what is the matter please?
Password is just password.
Thanks
James
Show as icon not working was created by james.me.robinson
Dear Bert,
I'm finishing off an overview sheet that averages scores across several tabs. I want the number to be represented by number icons so that it is easier to see at quick glance.
On the test mark book, it worked perfectly, but on the final version of the workbook, it doesn't seem to be working properly. It is showing 0 as an icon fine, but as soon as the number changes, the cell is empty.
I have attached the mark book. It is the APP sheet that I am looking at. The first set of columns is the average calculation column. The second set of columns is where I am trying to represent the number as an icon.
I have set up the icons as a grade so it should all work ok.
Would you be able to have a look and see what is the matter please?
Password is just password.
Thanks
James
Last edit: 8 years 3 months ago by james.me.robinson.
- james.me.robinson
- Topic Author
- Offline
Less
More
- Thank you received: 0
8 years 3 months ago #6482
by james.me.robinson
Replied by james.me.robinson on topic Show as icon not working
Managed to get it working. Had the wrong grade type in source cell.