I have a sheet that is using a Data Bar (conditional formatting). I was wondering if it is possible to change the color based on the score that is creating the bar graphic (ie score is between 0-20 : 2-6 should be red, 8-10 should be orange, 12-14 should be yellow, 16-20 should be green). So far I have only been able to do 1 color bar.
This may be possible using VBA, but I have played around trying different options, and what you want (change color based on value), does not seem possible with the data bar option. If yoy change to 3-color, it starts towards what you want, but then the bar lengths are all the same
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
That's kind of what I thought was going to happen. I guess I was hoping that I wouldn't have to try and remember how to do that!
Thanks for the reply
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks