With Excel you can not only calculate but also automatically color cells or rows in your table. depending on what is inside. With this conditional formatting, you make your tables clearer. For example, if you manage inventory with Excel, you can mark in red when a product is running low. Does that work without complicated formulas? we will show you how.
Color cells with Excel’s if function
If the functions allow you to mark cells in color based on their content. Excel offers you several 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.
Quick Start Guide:
- Mark The cells whose color should change according to the content.
- In the tab “start” in “Conditional format“.
- Go “Rules for highlighting cells“And choose the one you want rule outside.
- In the window, enter the exact condition when to change the cell color. Also choose what color cells are supposed to accept.
- Remove conditional formatting: Mark The cells that you want to format. Click on “Conditional format“then”Delete rules“Y”Delete rules in selected cells“.