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, |
All times are GMT +1. The time now is 02:54 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com