Excel: "If Then Color" - how to apply the function

In addition to simple and complex calculations, you can edit and manage your data sets with numerous other functions in Excel. But you can also change the format of individual cells depending on the content of the cells. For this purpose, for example, the "IF THEN Color" function is available to you.

This is what the "IF THEN color" function in Excel

Excel provides you with a function that allows you to set the format of a cell automatically, depending on what value it contains. For example, the "IF THEN Color" function is available for this purpose. In this way, cells are marked in a certain color if they exceed or fall below a certain value or meet other criteria. This type of function is a conditional formatting.

1. As criteria, you can specify whether a value is greater than or less than a certain value. But also whether this lies between two numbers or is equal to this number.
2. In addition, you can check whether a cell contains a certain text or a certain date.
3. Another option is to check whether a cell contains duplicate values.
4. To do this, select the cells that you want to check. Then click on the "Start" tab and select "Conditional formatting".
5. In the "Rules for highlighting cells" submenu, you can now set the various criteria.
6. Make sure to also enter the reference value with which the contents are to be compared. Confirm with "OK", all cells will be colored accordingly.