Using conditional formatting and IF Function to compare Actuals and Budgets in Excel
Follow
Use a combination of Conditional Formatting in Excel and IF Function to compare actuals and budgets. Color cells with arrows pointing up or down depending on whether the budget was over spent or under spent.