Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works

excel automatic functions - 2 tasks

  • Please log in to reply



    New Member

  • Member
  • Pip
  • 1 posts
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.

  • 0


Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP