Apply shading to alternate rows or columns in a worksheet
There are two ways to apply shading to alternate rows or columns —you can apply the shading by using a simple conditional formatting formula, or, you can apply a predefined Excel table style to your data.
Use conditional formatting to highlight information in Excel
Conditional formatting can help make patterns and trends in your data more apparent. To use it, you create rules that determine the format of cells based on their values, such as the following monthly temperature data with cell colors tied to cell values.
Add or change the background color of cells - Microsoft Support
Format cells in a worksheet by applying cell shading, using standard and custom colors, or remove a cell shading format from cells.
Change the color of text - Microsoft Support
On the Custom tab, in the Colors box, select the color you want. If you know the color numbers of a specific color, pick RGB (Red, Green, Blue) or HSL (Hue, Sat, Lum) in the Color model box, and then enter the numbers to match the exact color shade you want.
Apply a table style without inserting an Excel table
On the worksheet, select a range of cells that you want to format by applying a predefined table style. On the Home tab, in the Styles group, click Format as Table. Click the table style that you want to use.
Change the appearance of your worksheet - Microsoft Support
To change the text fonts, colors, or general look of objects in all worksheets of your workbook quickly, try switching to another theme or customizing a theme to meet your needs. If you like a specific theme, you can make it the default for all new workbooks.
Change the format of a cell - Microsoft Support
Go to the ribbon to select changes as Bold, Font Color, or Font Size. Select the cells. Select Home > Cell Style and select a style. Select the cells with the Excel Style. Right-click the applied style in Home > Cell Styles. Select Modify > Format to change what you want. Need more help?
Ways to format a worksheet - Microsoft Support
To distinguish between different types of information on a worksheet and to make a worksheet easier to scan, you can add borders around cells or ranges. For enhanced visibility and to draw attention to specific data, you can also shade the cells …
Change the colors in a text box or shape - Microsoft Support
On the Drawing Tools Format tab, click Shape Outline and, under Theme Colors, pick the color you want. To change the border to a color that isn't in the theme colors. Select the shape or text box.
Add or change the background color of cells - Microsoft Support
You can highlight data in cells by using Fill Color to add or change the background color or pattern of cells. Here's how: Select the cells you want to highlight. To use a different background color for the whole worksheet, click the Select All button.
Apply, create, or remove a cell style - Microsoft Support
Apply, create, or remove a cell style. To apply several formats in one step, and to make sure that cells have consistent formatting, you can use a cell style. A cell style is a defined set of formatting characteristics, such as fonts and font sizes, number formats, cell borders, and cell shading.