sjoerd.bosch
New Member
- Joined
- Feb 9, 2012
- Messages
- 49
Hi
I am looking for a code what fills the ranges of cells P1, S1, P2, S2, etc partially - entering the values in range cells C5 for P1, D5 for S1, etc -
with the colours listed in cells C14:C20 - the colours are defines in the range C23:C36
result should look P1 15% filled and colour orange
If I change cell C23 to 5 - it should change to yellow
If I change value in C5 to 50 - fill should be 50%
etc
I managed to get it done with Sparklines - but it does not completely cover the range of cells
Tried with shapes - which I cannot manage
Any ideas - solution are very much appreciated
I am looking for a code what fills the ranges of cells P1, S1, P2, S2, etc partially - entering the values in range cells C5 for P1, D5 for S1, etc -
with the colours listed in cells C14:C20 - the colours are defines in the range C23:C36
result should look P1 15% filled and colour orange
If I change cell C23 to 5 - it should change to yellow
If I change value in C5 to 50 - fill should be 50%
etc
I managed to get it done with Sparklines - but it does not completely cover the range of cells
Tried with shapes - which I cannot manage
Any ideas - solution are very much appreciated