I am trying to create a form colored scroll box into excel that lists
SCALE of 100% to 70%.
Where 100% = all green, 95%=2/3, 1/3 yellow, 90%=1/3 green, 2/3 yellow
85%= all yellow, 80%=1/3 red, 2/3 yellow, 80=1/3 red, 2/3 yellow
75%=2/3 red, 1/3 yellow, 70%=all red.

So when I click onto either the right or left arrow, and stop at sa
85%, the bar will appear all yellow.
Can anyone help me create this?

--
Message posted from http://www.ExcelForum.com