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.

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.

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.