| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Shading cells in a row based on another cell
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 +------------------------------------------------------------------- -- matp ----------------------------------------------------------------------- matpj's Profile: http://www.excelforum.com/member.php...fo&userid=2107 View this thread: http://www.excelforum.com/showthread.php?threadid=53261 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Shading Cells based on Date | Excel Worksheet Functions | |||
| Is there a way to add cells based on their shading / fill colour? | Excel Discussion (Misc queries) | |||
| Conditional Cell Shading (based on the shading of other cells) | Excel Worksheet Functions | |||
| Apply cell shading based on adjacent cells in EXCEL | Excel Worksheet Functions | |||
| Shading cells based on Other Sheet Value? | Excel Programming | |||
![matpj[_61_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
