Fill Color related to % complete
 

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.

Fill Color related to % complete
 

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.

Fill Color related to % complete
 

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.

Fill Color related to % complete
 

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.

Fill Color related to % complete
 

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.

Fill Color related to % complete
 

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.

Fill Color related to % complete
 

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.

Fill Color related to % complete
 

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

Fill Color related to % complete
 

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

Fill Color related to % complete
 

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

Fill Color related to % complete
 

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

Fill Color related to % complete
 

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.