View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default Progress / Completion bars. Help if you like a challenge!

Hi Callum,

Am Tue, 2 Jun 2015 12:03:12 +0100 schrieb Callum:

Thank's for the effort Claus B. B4 however doesn't function correctly,
it fills to 100% when A1=700 instead of A1=1300 (as it should only be
full once B2 and B3 are full which means B4=0 when A1=600)


Sorry for the misunderstanding.

Look again:
https://onedrive.live.com/redir?resi...=folder%2cxlsm
for "Data Bar"
I changed the absolute values that it is easier to handle.


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional