Excel Guides

How to Change Cell Colors in Excel

You can change the color of individual cells or ranges of cells in Excel. This is useful for highlighting data or drawing attention to a particular cell or range of cells.

To Change the Color of a Single Cell:

  1. Select the cell or range of cells that you want to change the color of.
  2. On the Home tab, in the Font group, click the arrow next to Fill Color, and then click the color that you want.

To Change the Color of Multiple Cells:

  1. Select the cells or ranges of cells that you want to change the color of.
  2. On the Home tab, in the Font group, click Fill Color, and then click More Colors.
  3. In the Colors dialog box, under Standard colors, click the color that you want, or mix your own color by clicking Customize Colors.
  4. (Optional) To add this color to the Standard colors or Recent colors list so that you can use it again easily, click Add to Custom Colors.
  5. (Optional) To create a custom color that you can name and save for future use, click Create New Theme Colors, and then name and mix your own custom color under Define Custom Colors.
  6. (Optional) To get colors from another workbook or graphic file (such as a .gif file), click Import.
  7. (Optional) If you want to base your custom colors on one of Excel's built-in color schemes so that your custom colors will match if someone else opens your workbook using a different computer monitor or printer, select a scheme from the drop-down list next to Base Theme on Existing Document's Colors.
  8. (Optional) If you want your changes to affect only this workbook and not templates on which it is based, select All Modifications Are Saved In This Workbook Only from the drop-down list next to Save Changes In.
  9. Click OK when done making changes in this dialog box.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.