Without Excel 2007..............one color only.


Gord Dibben MS Excel MVP

On Wed, 16 Sep 2009 14:59:01 -0700, Dawn
wrote:

Can I do conditional formatting of the bars - in other words, pick the colors
based on a condition or am I stuck with one color?

"Bob Umlas" wrote:

Need excel 2007

"Dawn" wrote in message
...
Is there a way to have a cell partially shaded based on a percentage in
that
cell in Excel 2003?

Column B has a %
Column C has a status

I have conditional formatting in Column B That if the value in Column C is
"On Schedule" color is green, if value is "Behind Schedule" color yellow,
if
the value is "In Trouble" color red.

i want to keep the colors but base the horizontal shading on the
percentage
in column B.

Can this be done?

Help and thank you,