You can use Find/ Replace to change the formatting of cells. In the spreadsheet below, this is useful if you need to change all the blue cells to yellow.
Excel replaces only the formats, so all the blue cells will turn to yellow.
To see the full course contents click here.