You cannot color part of a cell using CF.

All or nothing.

You would need VBA to draw a colored rectangle that fit only part of the
cell depending upon percent complete.

Rather fiddly and prone to mucking up if users change row heights or column
widths.


Gord Dibben MS Excel MVP

On Wed, 29 Apr 2009 13:45:02 -0700, 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.