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.

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.

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.

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.

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.

I was thinking about doign conditional formatting now you probably need A
MAcro or maybe some VBA code I dotn have Excel 2003 how many conditions can
you do with it in the conditional formatting area??

"northstar" wrote:

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.

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.

On Apr 29, 5:48 pm, 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.

Try this:

C2 = REPT("–ˆ";B2)

and choose an appropriate font color . - Does it help?

Have fun
Michael

On Apr 29, 5:48 pm, 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.

Try this:

C2 = REPT("–ˆ";B2)

and choose an appropriate font color . - Does it help?

Have fun
Michael

On Apr 30, 10:31 pm, "Michael.Tarnowski" wrote:
On Apr 29, 5:48 pm, 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.

Try this:

C2 = REPT("–ˆ";B2)

and choose an appropriate font color . - Does it help?

Have fun
Michael

In addition I found this link: http://www.excelitems.com/2009/03/co...-macro-or.html

On Apr 30, 10:31 pm, "Michael.Tarnowski" wrote:
On Apr 29, 5:48 pm, 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.

Try this:

C2 = REPT("–ˆ";B2)

and choose an appropriate font color . - Does it help?

Have fun
Michael

In addition I found this link: http://www.excelitems.com/2009/03/co...-macro-or.html

Michael.Tarnowski wrote:
On Apr 29, 5:48 pm, 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.

Try this:

C2 = REPT("–ˆ";B2)

and choose an appropriate font color . - Does it help?

Have fun
Michael


Actually, something similar to this could work pretty well:

=REPT("–ˆ",B2*CELL("width",C2)*0.78)

With the "0.78" adjusted for your font size settings. "0.78" was pretty good
for 10pt Arial.