Ideally no set increment, just mimic whatever % is entered in the data as
would occur if I created a chart with the numeric data. But, if need be, I
can live with 10% increments. Thanks for hanging in with me.

"Pimamedic" wrote:

AT what point do you want the cell to get darker ie every 25% or every 10%
change??

"northstar" wrote:

v2003.

"Pimamedic" wrote:

What version of excel are you using??

"northstar" wrote:

I have identified start/finish dates for various tasks, each on seperate
rows, e.g. 2, 4, 6,8, and 10. Column A is the task name. Column B cell
contains percent complete, e.g. .25, .80, 1.00. Example: I want C2 to be
partially/completely shaded, depending upon the number entered in B2. Is this
possible with conditional formatting? If so, please explain.