Hi,

Am Mon, 20 Oct 2014 08:39:32 +0100 schrieb Horus:

I am trying to make use of the data bars option under Conditional
Formatting. I want the value of the conditonally formatted cell to
determine the length of the bar. Thus far everything is fine! Then I
want another value to determine the color of the bar
(red/yellow/green).

you have to use VBA.

Please look he
https://onedrive.live.com/?cid=9378A...121822A3%21326
for workbook "CF_issue_Horus"


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional