Question

Which is the quickest way to change the font color in multiple, randomly located cells in a worksheet?Select one of the options below as your answer: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

"C" could be OK and pretty fast in case you do not have too many cells. AutoFormat (if you mean format as table/styles) will format the whole table.