Highlight All Formula Cells with Color in Excel Office 365!!
Tags: highlightallformulac, kutoolsexceltutorial, kutools
Published: 2020-10-05 12:07:23

---
title: Highlight All Formula Cells with Color in Excel Office 365!!
published: true
date: 2020-10-05 11:44:02 UTC
tags: HighlightAllFormulaC,KutoolsExcelTutorial,Kutools
canonical_url: https://geekexcel.com/highlight-all-formula-cells-with-color-in-excel-office-365/
---

Here, we come up with the steps to **Highlight All Formula Cells with Color in Excel Office 365** using **Kutools.** Let’s get into this article!! Get an official version of **MS Excel** from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.

## Steps to Highlight All Formula Cells with the Specified Color:

To highlight all formula cells with the specified color, follow the below instructions.

- First, you need to activate the worksheet in which you want to highlight the formula cells.
- If you don’t have the **Design Tab** in your Excel sheet, you need to enable it by clicking the **Worksheet Design** option under the **Kutools Plus** Tab.

![select the Worksheet Design option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/EXCEL_cJkt0ALDpj.png)<figcaption id="caption-attachment-15195">select the Worksheet Design option</figcaption>

- Now, it will add the **Design Tab**.
- You need to **click** the **Highlight Formulas** option in the **View** section.

![Highlight Formulas option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/1-8.png)<figcaption id="caption-attachment-15211">Highlight Formulas option</figcaption>

- Then, all the formula cells in the current spreadsheet have been highlighted as shown in the below image.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Output-7.png)<figcaption id="caption-attachment-15212">Output</figcaption>

### Note:

- When you **close** the **Design Tab,** the **Highlight Names** feature will turn off.
- To change the highlight color, you need to go to the **Settings option** in the **Design Tab.**
- It will open the **Design Tools Settings dialog box** , where you need to specify the **Names Color.**

![Design Tools Settings Dialog box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Design-Tools-Settings-Dialog-box-1.png)<figcaption id="caption-attachment-15210">Design Tools Settings Dialog box</figcaption>

- **Click** the **OK** button.

## Summary:

In the above article, you can clearly learn the steps to **Highlight All Formula Cells with Color in Excel Office 365** using **Kutools ** with an example. Drop your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Read Ahead:

- [Count the Times a Word Appears in a Cell or a Range in Excel Office 365!!](https://geekexcel.com/count-the-times-a-word-appears-in-a-cell-or-a-range-in-excel-office-365/)
- [How to Extract Substring Between Two Texts in Excel?](https://geekexcel.com/how-to-extract-substring-between-two-texts-in-excel/)