Find Replace- Change formatting on many cells

Please purchase the course before starting the lesson.

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.

Find_Replace_7_formats

Excel replaces only the formats, so all the blue cells will turn to yellow.

Find_Replace_10_formats

To see the full course contents click here.

Back to: Intermediate Excel Course > Tools for text