Excel Dynamic Conditional Formatting: Create a User Controlled KPI Dashboard

This workbook shows you how you can setup dynamic conditional formatting in Excel using a user input area.  The Excel conditional formatting refers to cells within the dashboard which control the optimum and minimum sales targets.