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
 

Some videos you may like

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

Watch MrExcel Video

Forum statistics

Threads
1,122,224
Messages
5,594,916
Members
413,952
Latest member
JGer

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