If you are moving the row by cutting & pasting it from one sheet to another,
the cells' colors will move with the cells. If you are pulling values from
one sheet into another sheet using formulas, you will have to manually apply
the color formatting to the second sheet. Formulas only return values; they
can't change cell colors or borders. If the colors on the first sheet are the
result of conditional formatting, apply the same conditional formatting on
the second sheet. Or, you could select the row on the first sheet, then use
Format Painter to format the row identically on the second sheet.

Hope this helps,

Hutch

"Kingdazza" wrote:

I want to be able to have the colour of a cell move with a row from one
worksheet to another, what do I need to add to our current formula to achieve
this??