M
matpj
Hi everyone,
I have a sheet that has seperate rows for task ETCs
followed by (on the same row) a column for days used, remaining etc an
then a column fo each day) - almost like a gant chart but in excel.
I have attached the spreadsheet to this post.
I need to program something that will go through each row, look at th
number in column B, ans then shade from column E onwards by tha
number...
in the top row I have manually shaded the cells required.
can anyoen suggest how I coudl acheive this with VBA?
thanks in advance,
Mat
+-------------------------------------------------------------------
|Filename: gantsheet.zip
|Download: http://www.excelforum.com/attachment.php?postid=4624
+-------------------------------------------------------------------
I have a sheet that has seperate rows for task ETCs
followed by (on the same row) a column for days used, remaining etc an
then a column fo each day) - almost like a gant chart but in excel.
I have attached the spreadsheet to this post.
I need to program something that will go through each row, look at th
number in column B, ans then shade from column E onwards by tha
number...
in the top row I have manually shaded the cells required.
can anyoen suggest how I coudl acheive this with VBA?
thanks in advance,
Mat
+-------------------------------------------------------------------
|Filename: gantsheet.zip
|Download: http://www.excelforum.com/attachment.php?postid=4624
+-------------------------------------------------------------------