Form controls can be combined to create interactive dashboards. Practical applications include filtering data, tracking tasks, adjusting values, and switching data views.

If you support users who have trouble entering data and printing an Excel sheet, use this eight-step approach to create a foolproof form.

How to create conditional formatting rules in Excel Once the custom value formats exist, you can apply them using conditional formatting rules. Right now, the format is set to General.