Question

Which is the quickest way to change the font color in multiple, randomly located cells in a worksheet?

A.
Click the Format menu and select the AutoFormat option.
B.
Click the Font Color icon on the Formatting toolbar to change the font color of one cell, copy it with the Format Painter, and then paste it into each of the other cells.
C.
Hold down the Ctrl key, click on each cell, and then change the font color by clicking on the Font Color icon on the Formatting toolbar.

Answer 1

You could use the Format Painter, double clicking on it before it starts while selecting a cell that has the colour you want. You could also select the cells first, by clicking on them while holding the Ctrl key and then choose the colour you want from the font settings.

Step-by-step explanation: