Populate Complete Row with Color of First Cell in the Row

How to Populate Complete Row with Color of First Cell in the Row

There's more to this question than the simple statement above.

Why do this? What happens to the colours when a different row is selected?

Please explain fully.

Initially I have highlighted some bunch of rows with different colours, later i have formula in the first and cell, started dragging towards down, then formula got updated along with the first cell color.

I'm sorry. That doesn't explain anything.

Maybe:

Please Login or Register  to view this content.