Fill Color related to % complete

[northstar]

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.

 

[Pimamedic]

What version of excel are you using??

 

[northstar]

v2003.

What version of excel are you using??

 

[Pimamedic]

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

 

[northstar]

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]

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??

 

[Gord Dibben]

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

 

[Michael.Tarnowski]

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

 

[Michael.Tarnowski]

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

 

[Michael.Tarnowski]

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/color-only-part-of-cell-using-macro-or.html

 

[Michael.Tarnowski]

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/color-only-part-of-cell-using-macro-or.html

 

[Glenn]

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.