if cell colour is then change cell colour in range

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
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?
 
Back
Top