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.