Suppose we want to highlight the year number for each year during which sales were at least 5% higher than the previous year. We would begin by selecting the cell range D6:D12 and choose Conditional Formatting from the Ribbon. Then you would select new rules followed by the Use a Formula option. Finally you would enter the following formula. " (E5/E4)> 1.05 (SES6/E5)> 1.05 (E6E5)>1.05 (E6/E5)> 05 4 Year Actual Sales Cumulative Sales 4 Year Actual Sales Cumulative Sales 58 78 40 42 135 213 253 295 339 413 496 58 78 40 42 135 213 253 295 339 413 496 10 6 106 11 7 12 74 83 74 8 83