In a worksheet, you may need to fill color in different cells depending on the formula used in the sheets. I’m going to explain different ways of how to fill color in Excel using formula.

Here, I’m using a sample datasheet to show you the steps of the explained ways. It’s a pay sheet of several employees. There are 4 columns that represent the weekly, monthly, and yearly pay of an employee. These columns’ names are *Name**, Weekly Pay, Monthly Pay, *and

**.**

*Yearly Pay***Table of Contents** hide

Download to Practice

5 Ways to Fill Color in Excel Cell Using Formula

1. Using AVERAGE

2. Using ISFORMULA to Fill Color

3. Fill Color Using OR

4. Fill Color Using AND

5. Using Different Operators

I. Greater Than (>)

II. Not Equal (<>)

III. Equal (=)

IV. Less Than (<)

Practice Section

Conclusion

Related Articles

**Download to Practice**

Fill Color in Excel Cell Using Formula.xlsx

**5 Ways to Fill Color in Excel Cell Using Formula**

**1. Using AVERAGE**

If you have numeric values, you can use the AVERAGE function to fill color in a cell using a formula.

To use this function, first select the cell or the cell range where you want to apply this function to fill color.

Then, open the **Home** tab >> Go to **Conditional Formatting** >> Finally select **New Rule**

Now, a **dialog box** will pop up. From there you need to select **Use a formula to determine which cells to format **from **Select a Rule Type**.

Then, in **Edit the Rule Description** type the following formula.

`=$C4:$C14<=AVERAGE($C$4:$C$14)`

Now, from **Format** select the fill color of your choice to use it in a cell.

Here, the **AVERAGE **function will calculate the average of the selected cell range **C4:C14 **then will compare the average value with values of cell range **C4:C14**. Next, it will fill color where the cell value is less than average.

Finally, click **OK**.

Thus, it will show the cell filled with a selected format where the selected cell range is less than average.

**Read More: Excel Formula Based on Cell Color (5 Examples)**

**2. Using ISFORMULA to Fill Color**

You can use the **ISFORMULA **function to fill color in a cell if you have a formula in your cells.

First, select the cell range where you want to fill color using formula.

Second, open the **Home** tab >> go to **Conditional Formatting** >> then select the **New Rule**

Third, a **dialog box** will pop up. From the **Select a Rule Type **select **Use a formula to determine which cells to format**.

After that, in the **Edit the Rule Description** type the following formula.

`=ISFORMULA($D$4:$E$14)`

Now, from the **Format **choose the color of your choice to fill color in a cell.

I selected the cell range **D4:E14** as the **reference **of the **ISFORMULA** function to fill color.

*It won’t work on those cells where a formula is not applied.*

In the end, click **OK**.

As a result, it will show the cell filled with the selected format where the formula is used.

**Read More: How to Highlight Cell Using the If Statement in Excel (7 Ways)**

**3. Fill Color Using OR**

You can use the OR function to fill color in a cell using a formula.

To begin with, first, select the cell range where you want to apply this function to fill color.

After that, open the **Home** tab >> go to **Conditional Formatting** >> now select **New Rule**

After selecting **New Rule**, a **dialog box** will pop up. Now, From **Select a Rule Type: **select **Use a formula to determine which cells to format** rules.

There, in **Edit the Rule Description** type the following formula.

`=OR($C4<30, $D4=180)`

Then select the **Format **of your choice to fill color in a cell.

To use the **OR **function, I have taken two conditions. The 1st one is **C4<30** and the 2nd one is **D4=180**. In the selected cell range **B4:E14** if any of the conditions are fulfilled in any cell then it will fill color to that cell.

Finally, click **OK**.

Hence, it will show the cell filled with the selected fill color where one of the conditions is fulfilled.

**Read More:** How to Fill Cell with Color Based on Percentage in Excel (6 Methods)

**Similar Readings:**

- How to Highlight from Top to Bottom in Excel (5 Methods)
- VBA to Change Cell Color Based on Value in Excel (3 Easy Examples)
- How to Highlight a Column in Excel (3 Methods)
- How to Highlight Every 5 Rows in Excel (4 Methods)
- Highlight Cells That Contain Text from a List in Excel (7 Easy Ways)

**4. Fill Color Using AND**

You also can use the AND function to fill color in a cell using a formula.

First, select the cell range to apply the **AND** function to fill color.

Next, open the **Home** tab >> go to **Conditional Formatting** >> finally select **New Rule**

Now, a **dialog box** will pop up. From **Select a Rule Type **you need to select **Use a formula to determine which cells to format** rules.

Then, in **Edit the Rule Description** type the following formula.

`=AND($C4<50, $D4=180)`

Now you can select the **Format **of your choice to fill color in a cell.

Here, I also used two conditions within the **AND **function. The 1st one is **C4<50** and the 2nd one is **D4=180**. In the selected cell range **B4:E14** if both of the conditions are fulfilled in any cell that cell will be filled with color otherwise not.

Finally, click **OK**.

Therefore, it will show the cell filled with the selected format where two of the conditions are fulfilled.

**Related Content:** How to Change Cell Color Based on a Value in Excel (5 Ways)

**5. Using Different Operators**

You also can use the various **Operators **to fill color in any cell using formula.

#### I. Greater Than (>)

Here, I am going to use the **Greater Than **operator to fill color in the cell using the formula.

To begin with first select the cell or cell range to apply the formula.

Now, open the **Home** tab >> Go to **Conditional Formatting** >>Then select **New Rule**

Then, a **dialog box** will pop up. From **Select a Rule Type **you can select **Use a formula to determine which cells to format** rules.

Now, in **Edit the Rule Description** type the following formula.

`=D4 *12 > 1800`

Next, select the **Format **of your choice to fill color in a cell.

Here, I used the **(>) greater than** operator to check where **D4*12** is **greater than 1800**. Now, in the selected cell range **B4:B14** it will fill the rows where the conditions are fulfilled.

In the end, click **OK**.

Then, it will show the cell filled with the selected format where **D4*12** is **greater than 1800**.

**II. Not Equal (<>)**

To fill color in the cell using the formula here I am going to use the **Not Equal **operator.

Now to use the **Not Equal **operator, first select the cell or cell range to apply the formula.

Then, open the **Home** tab >> go to **Conditional Formatting** >> now select **New Rule**

A **dialog box** will pop up. Now, from **Select a Rule Type **you need to select the **Use a formula to determine which cells to format**.

Next, in **Edit the Rule Description** type the following formula.

`=C4*4 <> 180`

From the **Format **option, you can select the **format **of your choice to fill color in a cell.

Here, I used the formula **C4*4 **and applied the condition where it is **not equal (<>)** **180**. Now, the operator will check where **C4*4** are **not equal **to** 180** in the selected cell range **B4:B14**. Then, it will fill the rows where the conditions are fulfilled.

Finally, click **OK**.

Here, it will show the cell filled with the selected format color where **C4*4** are **not equal **to **180**.

**III. Equal (=)**

By using the **Equal **operator, I will fill color in the cell.

You can also use the **Equal (=)** operator for that, first select the cell or cell range to apply the formula.

Then, open the **Home** tab >> go to **Conditional Formatting** >> then select **New Rule**

Now, a **dialog box** will pop up. In the dialog box from **Select a Rule Type **you can select **Use a formula to determine which cells to format** rules.

Then, in **Edit the Rule Description** type the following formula.

`=C4*4 = 180`

Next, from the **Format **options select the **format **of your choice to fill color in a cell.

On the spot, I used the **(=) equal** operator to check where **C4*4=180**. Now, in the selected cell range **C4:C14** it will fill the rows where the conditions are fulfilled.

Finally, click **OK**.

On the whole, it will show the cell filled with the selected format color where **C4*4** are **equal **to** 180**.

**IV. Less Than (<)**

You also can use the **Less Than **operator to fill color in Excel cells using formula.

First and foremost, select the cell or cell range to apply the **Less than **operator.

After that, open the **Home** tab >> go to **Conditional Formatting** >>now select **New Rule**

Then, a **dialog box** will pop up. In the **dialog box**, from the** Select a Rule Type **you need to select **Use a formula to determine which cells to format** rules.

Next, in **Edit the Rule Description** type the following formula.

`=$D4:$D14<180`

Along with, select the fill color of your choice from the **Format** options.

Now, I used the **(<) less than** operator to check which values of range **D4:D14** are **less than 180 **of the ** Monthly Pay **columns. Now, the color will be applied to the cells where conditions are fulfilled.

Finally, click **OK**.

Hence, as I applied this formula in the range **B4:E14 **so it will fill color in those rows where the value of ** Monthly Pay** is

**less than 180**.

**Related Content:** How to Highlight Selected Cells in Excel (5 Easy Ways)

## Practice Section

I’ve provided an extra practice sheet in the worksheet so that you can practice these explained methods to fill color in the cell using formula.

## Conclusion

In this article, you will find 5 ways to fill color in Excel cell using formula. These methods will be useful for you whenever you want to fill color in a cell using formula. In case you have any confusion or question regarding these methods you may comment down below.

**Related Articles**

- How to Highlight Cells Based on Text in Excel [2 Methods]
- How to Highlight a Row in Excel (5 Quick Methods)
- Excel VBA to Highlight Cell Based on Value (5 Examples)
- How to Highlight a Cell in Excel (5 Methods)