Sobresalir: "SI ENTONCES color" aplicar

Standing out: "IF THEN color" Apply

monitor

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.

1st step:

Mark In your table, you select the cells that should change their color based on the content.

×

2nd step:

At the top of the tab, clickstart” In the area “Styles” in “Conditional format“. Follow”Rules for highlighting cells“And choose the one you want rule outside. In the example, cells whose value is less than 100 will be marked in color. Here’s how tight stocks stand out.

×

3rd step:

In the window, enter the exact condition when to change the cell color. Also, choose which one colour cells are supposed to accept. In the example, cells should be marked in red if an item’s inventory falls below 100 pieces.

×

4th step:

Would you like the conditional formatting cancel again, Proceed as follows: Mark The cells that you want to format. Click on “Conditional format“then”Delete rules“Y”Delete rules in selected cells“.

×

Quick Start Guide:

  1. Mark The cells whose color should change according to the content.
  2. In the tab “start” in “Conditional format“.
  3. Go “Rules for highlighting cells“And choose the one you want rule outside.
  4. In the window, enter the exact condition when to change the cell color. Also choose what color cells are supposed to accept.
  5. Remove conditional formatting: Mark The cells that you want to format. Click on “Conditional format“then”Delete rules“Y”Delete rules in selected cells“.