Hi
I hope that my request can a) be done in excel and b) that someone can show me how.
I have built a pivot table to record scores on hierarchy based table. I have the table built and everything works fine except where the volume of responses is less than 5 I do not want it to show the score. The only way I have found to do this is to use conditional formatting to colour the cell and font the same where the responses are below 5. I can't just disregard the score as there are 4 hierarchy levels. All the scores make up the top level so need to be included. This all works fine but the problem I have is if I hover the mouse over the conditionally formatted cell a small window/box comes up next the mouse pointer and shows the name of the column, the value of the cell, the row path and the column title again. It's this that I do not want to show as it negates the conditional formatting.
I have attached a screenshot showing the box.
Thanks
localpunter
Bookmarks