1st question: The rows are left white(uncolored), so how do I specify colors in rows?
2nd question: Yes, I need to move formula to a different cell within the row, also I need to modify one of the cell formulas. Could you explain how to do this within the macro?