Data Bars in Excel 2007
I am able to have conditional formatting for one color in 2007 and apply the
data bars to the percentages but 25% and 50% have the same bar length.
Shouldn't they be different? What am I doing wrong? I have them set up as
percentage with 0 for min and 100 for max.
"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,
|