consolidated data overview & warning when limit is reached in total

felicity1point6

New Member
Joined
Apr 12, 2013
Messages
1
Subject: consolidated data overview & warning when limit is reached in total
Hi there,
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.
Fliss
 

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,899
Messages
5,834,299
Members
430,275
Latest member
Halis

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top