DuncanMeyers
New Member
- Joined
- Aug 31, 2006
- Messages
- 3
Hi there,
I have a problem with trying to conditionally format my column chart.
I've read other posts to try and find an answer but none of them go into the detail I need.
I have 6 values which are plotted on the graph, each value has a different set of conditional formatting values (this is where it differs to other conditional formatting questions).
For instance I have the values:
1) 1316.6
2) 26.4
3) 127.24
4) 20
5) 167.7
6) 737.45
Now there are 3 conditions to which I would like the graph to be formatted. If the value is below Tier 1 then for the column to be Light Green, if the value is above Tier 1 then for the column to be Tan and if the value is above Tier 2 then for the column to be Rose.
My problem is that the 6 values above have the following "Tier Levels"
Tier 1 Tier 2
1) 5000 50000
2) 5000 50000
3) 10 50
4) 200 500
5) 500 2000
6) 500 2000
Which would mean values 1,2, 4 and 5 Would be Light Green, value 3 would be Rose and value 6 would be Tan.
I am using Excel 2003 on windows XP. I hope I have given you as much information as needed, but if there is anything I've missed out just ask and I'll try to inform you of it.
Thank you very much for any help, it is all appreciated.
Duncan
I have a problem with trying to conditionally format my column chart.
I've read other posts to try and find an answer but none of them go into the detail I need.
I have 6 values which are plotted on the graph, each value has a different set of conditional formatting values (this is where it differs to other conditional formatting questions).
For instance I have the values:
1) 1316.6
2) 26.4
3) 127.24
4) 20
5) 167.7
6) 737.45
Now there are 3 conditions to which I would like the graph to be formatted. If the value is below Tier 1 then for the column to be Light Green, if the value is above Tier 1 then for the column to be Tan and if the value is above Tier 2 then for the column to be Rose.
My problem is that the 6 values above have the following "Tier Levels"
Tier 1 Tier 2
1) 5000 50000
2) 5000 50000
3) 10 50
4) 200 500
5) 500 2000
6) 500 2000
Which would mean values 1,2, 4 and 5 Would be Light Green, value 3 would be Rose and value 6 would be Tan.
I am using Excel 2003 on windows XP. I hope I have given you as much information as needed, but if there is anything I've missed out just ask and I'll try to inform you of it.
Thank you very much for any help, it is all appreciated.
Duncan