Mr Mez
04-16-2008, 11:03 AM
Little about me as its my first post!!
23 year old male loving life and happerly engaged. working for a large world wide company (McDonalds! I'm far from ur streriotyping!) as a 1st assisatant Store mgr.Enjoy everything to do with computing such as simple day to day work, building my own, and also gaming. have an IQ of 138 (like to slip that in when possible!)
Studied a little at school/collage about simple programing in VB/excel eg forms macros etc but that was 5years ago and really wish i had taken it further! 5 years has past and can only really remember the very basics.
:confused: PROBLEM:
I am creating a table for work to work out avargae times of service of chicken products through the day. We get a print out from the tills and it has Transcount (number of customers) and average time for that hour. so the table is quite simple. See below:
The problem i have is that i need to make it so that when a number is added into the time colums, the cell colour chages depending what the number in it. for instance, if the number is 0 then there is no colour, under 35 will be bright green ( ColourIndex 4), 35 to 50 will be Orange (ColourIndex 45) and over 50 Red (ColourIndex 3).
Is this at all possible that you can create a cell to do this and still enter numbers into it???
Does this make sence????
Thanks in advance!
Mr Mez
23 year old male loving life and happerly engaged. working for a large world wide company (McDonalds! I'm far from ur streriotyping!) as a 1st assisatant Store mgr.Enjoy everything to do with computing such as simple day to day work, building my own, and also gaming. have an IQ of 138 (like to slip that in when possible!)
Studied a little at school/collage about simple programing in VB/excel eg forms macros etc but that was 5years ago and really wish i had taken it further! 5 years has past and can only really remember the very basics.
:confused: PROBLEM:
I am creating a table for work to work out avargae times of service of chicken products through the day. We get a print out from the tills and it has Transcount (number of customers) and average time for that hour. so the table is quite simple. See below:
The problem i have is that i need to make it so that when a number is added into the time colums, the cell colour chages depending what the number in it. for instance, if the number is 0 then there is no colour, under 35 will be bright green ( ColourIndex 4), 35 to 50 will be Orange (ColourIndex 45) and over 50 Red (ColourIndex 3).
Is this at all possible that you can create a cell to do this and still enter numbers into it???
Does this make sence????
Thanks in advance!
Mr Mez