Conditional formatting

[Debbie]

I need to apply conditional formatting to a pivot chart that needs to reflect
drops in revenue for consecutive months. The chart is setup as follows.

Jan-04 Feb-04 Mar-04 April-04 etc.
collections 65,333 65111 64333 59000

I need to have the colors change on the month that collections drops for the
1st time, and then change to a different color if it reaches a decline for
two consecutive months and again change to red when collections has declined
for three + consecutive months, and of course remain uncolored if does not
meet one of these criteria.

Any suggestions for how I can make something like this apply to this will be
appreciated.

 

[Debra Dalgleish]

Select the cells that you want to format
Choose Format>Conditional Formatting
From the first dropdown, choose Formula Is
In the text box, type: =AND(B6<B5,B5<B4,B4<B3)
where cell B6 is the active cell in the selection
Click the Format button, and select the Patterns tab
Choose the Red fill colour
Click OK, then click the Add button.

From the first dropdown, choose Formula Is
In the text box, type: =AND(B6<B5,B5<B4)
where cell B6 is the active cell in the selection
Click the Format button, and select the Patterns tab
Choose the Orange fill colour
Click OK, then click the Add button.

From the first dropdown, choose Formula Is
In the text box, type: =B6<B5
where cell B6 is the active cell in the selection
Click the Format button, and select the Patterns tab
Choose the Yellow fill colour
Click OK, click OK