View - Display Marked Cells

Ribbon bar. Select the View tab. In the Display group, click Display Options and from the menu, select Marked Cells...

Classic menus. From the View menu, select Display Marked Cells (or click the toolbar button on the Spreadsheet toolbar)...

...to toggle between displaying and not displaying marked cells in the spreadsheet. If you select to display marked cells, they will have a different spreadsheet layout applied to them to make them stand out from the rest of the data. By default, marked cells appear red, but this default Marked Cells Spreadsheet Layout can be changed:

Ribbon bar. Select the Tools tab. Click Marked Cells and from the menu, select Edit Marked Cells Layout to display the Edit Spreadsheet Layout: Marked Cells dialog box, where you can change the format.

Classic menus. From the Tools - Marking Cells submenu, select Edit Marked Cells Layout to display the Edit Spreadsheet Layout dialog box.

See also: Format - Overview, Spreadsheet Layouts - Overview, and Tools - Marking Cells - Display.