Question

Excel: "IF THEN color" apply

Answer 1

Color cells with Excel's If function
1st step:
2nd step:
3rd step:
4th step:
Quick start Guide:

---

Here we show you how to color individual cells in Excel depending on their content..

With Excel, you can not only calculate, but also automatically color cells or rows in your table, for example - depending on what is in them. With this conditional formatting you make your tables clearer. For example, if you manage inventory with Excel, you can have it highlighted in red when a product is running low. You can do this without any complicated formulas - we'll show you how.

Color cells with Excel's If function

If functions allow you to mark cells in color depending on their content. Excel offers you various options for this: For example, you can mark cells whose value exceeds or falls below a certain value, but also cells that contain certain text. Follow our step-by-step instructions or take a look at the quick start guide .

1st step:

Select the cells in your table that should change their color depending on the content.

2nd step:

Click the top of the tab " Start " in the " styles " to " Conditional Formatting ". Go to " Cell Highlighting Rules " and select the rule you want. In the example, the cells whose value is less than 100 are to be highlighted in color. In this way, short stocks are highlighted.

3rd step:

In the window , enter the exact condition when the cell color should change. Also, choose what color you want the cells to be. In the example, the cells should be marked red if the inventory of an item falls below 100 pieces.

4th step:

If you want to remove the conditional formatting , proceed as follows: Select the cells for which you want to remove the formatting. Click " Conditional Formatting " again, then click " Clear Rules " and " Clear Rules In Selected Cells ".

Quick start Guide:

1. Select the cells whose color should change depending on the content.
2. In the " Start " tab, click on " Conditional Formatting ".
3. Go to " Cell Highlighting Rules " and select the rule you want.
4. In the window , enter the exact condition when the cell color should change. Also choose what color you want the cells to be.
5. Undo conditional formatting: Select the cells for which you want to undo the formatting. Click " Conditional Formatting " again, then click " Clear Rules " and " Clear Rules In Selected Cells ".

---