View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Michael.Tarnowski Michael.Tarnowski is offline
external usenet poster
 
Posts: 95
Default 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