bluenose76
Registered User.
- Local time
- Today, 17:41
- Joined
- Nov 28, 2004
- Messages
- 127
I need a little help please,
My workbook has many worksheets, all of which contain various pieces of data. each sheet has its own formulas and are working well.
the first worksheet in my workbook is a summary page to show graphically how each of the sheets are doing
eg:
sheet 1 jobs = 47%
pay = 72%
cars = 51%
Sheet 2 jobs = 99%
pay = 17%
cars = 100%
Sheet 3
Sheet 4
etc etc
What i would like to have is a little VB code in the background that will shade the cells according to the percentage show (The percentage is simple a linked cell to the respective sheet)
<50 = Red
>50 but less than 100 = Amber
100 = Green
i am also all ears to any other suggestions as to how better to display the above information, other than just a test box?
thank you al in advance
Arran
My workbook has many worksheets, all of which contain various pieces of data. each sheet has its own formulas and are working well.
the first worksheet in my workbook is a summary page to show graphically how each of the sheets are doing
eg:
sheet 1 jobs = 47%
pay = 72%
cars = 51%
Sheet 2 jobs = 99%
pay = 17%
cars = 100%
Sheet 3
Sheet 4
etc etc
What i would like to have is a little VB code in the background that will shade the cells according to the percentage show (The percentage is simple a linked cell to the respective sheet)
<50 = Red
>50 but less than 100 = Amber
100 = Green
i am also all ears to any other suggestions as to how better to display the above information, other than just a test box?
thank you al in advance
Arran
