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

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

Forum statistics

Threads
1,214,780
Messages
6,121,522
Members
449,037
Latest member
tmmotairi

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
Back
Top