Annual Expense Report with Traffic Lights on Excel spreadsheet

Traffic lights on excel spreadsheet

Download: Annual Expense Report

File format: Excel

How to change conditional formatting

  1. Select the cells you want to change.
  2. On the Home tab, click Conditional Formatting. (It’s in the Styles section)
  3. Click Manage Rule from the drop-down menu.

How to use the Excel template

Enter values in each of the columns. The financial numbers are calculated automatically.

Related MS Office Templates

Download More MS Word and Excel templates

Related Apple iWork Templates

Download More Apple Number and Pages Templates