In this Excel video tutorial, we gonna see How to Automatically Highlight Cells in Excel using Check Boxes and DrowDown Lists.

You can highlight an entire row in Excel or just a especifc cell that matches a certain criteria.

Whenever the condition is met, the value is automatically highlight with a green color or red color or any other custom color that you wanna use.

To have acess to the check boxes, we first need to know how to enable the developer tab in Excel.

The check boxes can be used to control custom conditional formatting. You can enable or disable the conditional formatting through the check boxes.

The drop down list in excel or the option list in the cell, can be used with similar purpose.

But, both can allow you to analyze your data easily to see which values stand out or need a closer look.

Talking about excel formulas or excel function, we gonna need to use three most important function in Excel, if formula and max formula and min formula.

#JopaExcel #Dashboard #Excel