Conditionally Format Bars

The easiest way to do this is not to use a chart at all (the old fashioned way!)
Use the REPT function to create the 2 bars
Then conditionally format based on whether value A or value B is the greater

See attached workbook and try different values in A3 and B3

The trick:
1. Formulas in cell A1 and B1 respectively:

Formula:

=REPT("g",A3/10)

=REPT("g",B3/10)

2. Cells A1 and B1 font = Marlett

3. Cells A1 and B1 conditionally formatted based on relative values of A3 and B3

so dependent on whichever value is greater, either A1 or B1 is conditionally formatted green
trickery.jpg


Otherwise, here is a good place to start reading