Return workbook cell formatting

If you want to set the cell font or cell fill you should use Return workbook cell formating option.
To use it go to Tools menu -> Return workbook cell formatting

You can select 1 or multiple cells and then select the color in Select cell formatting section and click Apply formatting button.

It is possible to select only font or only fill, or both fill and font at the same time.
To update only the fill or only the font, you should leave the option not to be changed as ‘No Change’

In case cell formatting which was selected earlier is no longer required, you can select Default checkbox -> Apply formatting button and they will set as default (eg. with white fill and black font)

Note: Only cells of the active worksheet can be formatted, you can not select multiple sheets and use this feature.

Note: Locked cells, such as Tabular formulas, cannot be formatted. So they will be skipped in case they are selected.