Solid conditional formatting Excel

**okeefe87** · 03-18-2010, 06:07 AM

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** · 03-18-2010, 07:12 AM

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.