Excel 2007 : Solid conditional formatting Excel

[okeefe87]

Hello, new on the forum but really stuck on excel. I'm using Excel 2007 and trying to conditionally format a series of cells to illustrate the percentage distribution of a total.

I.e

cell A1:100,000
A2:35%
A3:65%
A4:Conditional formatting to highlight distribution

On the conditional formatting I can only find a graded scale but need the bar to be a solid fill with clear definition of the two values ideally with a midpoint bar.

Any help on this matter is greatly appreciated.

Regards,

Mark

[rwgrietveld]

This is not my specialty,

But I found that Bar Appearance, Fill can be set to either:
Solid Fill / Gradient Fill

And in a sub menu "Negative Value abd Axis" one can have that Mid point.

[okeefe87]

I can fill the cell but not the bar and can't find the sub menu. Any screen shots?

Cheers,

Mark