| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
cell color adjustment using vba
My dear! There are 12 columns(months). 50 rows each column. Each is marked by its own color. SAy cell G5 data ( in January) is marked green and i need to transfer cell data to H5 (Feb)blue. I need the cell color(green) be changed for (blue) automatically. So at the whole table. How can i do it using VBA ? Or something else. Help me please. Serge. -- Kaibutsu ------------------------------------------------------------------------ Kaibutsu's Profile: http://www.excelforum.com/member.php...o&userid=26168 View this thread: http://www.excelforum.com/showthread...hreadid=394867 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
cell color adjustment using vba
Is it as simple as?
For Each cell In Range("G5:G54") cell.Offset(0,1).value = cell.value cell.Offset(0,1).interior.Colorindex = 5 Next cell -- HTH RP (remove nothere from the email address if mailing direct) "Kaibutsu" wrote in message ... My dear! There are 12 columns(months). 50 rows each column. Each is marked by its own color. SAy cell G5 data ( in January) is marked green and i need to transfer cell data to H5 (Feb)blue. I need the cell color(green) be changed for (blue) automatically. So at the whole table. How can i do it using VBA ? Or something else. Help me please. Serge. -- Kaibutsu ------------------------------------------------------------------------ Kaibutsu's Profile: http://www.excelforum.com/member.php...o&userid=26168 View this thread: http://www.excelforum.com/showthread...hreadid=394867 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro adjustment | Excel Discussion (Misc queries) | |||
| Auto Cell Height Adjustment for text entered | Excel Discussion (Misc queries) | |||
| Using Cell Data as adjustment to formula references | Excel Worksheet Functions | |||
| Excel: Syntax to change cell color based on color of another cell | Excel Worksheet Functions | |||
| Event Macro adjustment needed - need to change font color also | Excel Worksheet Functions | |||
Linear Mode
