I am hoping that some excel wiz will be able to help me with these two tasks please.
1. I have 6 tabs representing different categories, but with the same data headings in each category (date, person, volume). I have consolitated this information into 1 overview on another tab, where the volume for each date is totaled into one cell. I would like to for example run the mouse over these total cells in the overview tab and see the breakdown and from which category (tab) it came from, e.g' cell would read '60' and when the mouse was moved over it, a note would come up which would read for example '10 black, 30 white, 20 red'
2. I would like to create a rule whereby if the total in the 'overview' tab (consolidated data) is greater than 50, it turns red.
I hope that this is clear,
Please do ask any questions if it is not.
Many thanks in advance.