| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
if cell colour is then change cell colour in range
I am trying to write a macro that changes the cell colour in a range of cells
based on the cell colour in the row. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
if cell colour is then change cell colour in range
hi,
could you be more specific. does range of cells mean a block of cells? if so, how bigs? based on what row? more info please. regards FSt1 "tiger" wrote: I am trying to write a macro that changes the cell colour in a range of cells based on the cell colour in the row. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
if cell colour is then change cell colour in range
Sorry,
I have a cell identified by either the word "Unbene" or the interior cell colour. I want to write a macro that will identify that cell and then colour 9 cells in the same row. The word is in cell C and I want cells A-I change to a colour I designate. Is this clearer? "FSt1" wrote: hi, could you be more specific. does range of cells mean a block of cells? if so, how bigs? based on what row? more info please. regards FSt1 "tiger" wrote: I am trying to write a macro that changes the cell colour in a range of cells based on the cell colour in the row. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can colour of cell shading be fixed to one colour | Excel Discussion (Misc queries) | |||
| change current cell colour based on the value of adjacent cell on other worksheet | Excel Programming | |||
| change a cell background colour to my own RGB colour requirements | Excel Discussion (Misc queries) | |||
| How can i change cell colour depending on month of date in cell? | Excel Discussion (Misc queries) | |||
| Change cell colour for a cell or range within a predefined range | Excel Programming | |||
Hybrid Mode
