Microsoft Excel Functions & Formulas

Use the OR function to indicate differences

higher than 5% and lower than –5%

At the end of a fiscal year a company compares the monthly sales of

the last two years. Take a look at the following sales report for 2004

and 2005. Monthly sales of fiscal year 2004 are listed in column B,

and column C contains the sales for 2005. Check the difference in

column D by inserting the formula =(C2/B2)-1 and format it to per-

centages with one decimal place. The following steps show how to

use conditional formatting to shade each cell that meets the desired

condition.

4

To shade differences higher than 5% and lower than -5%:

1. Select cells C2:C13.

2. On the Format ...