help with formula

C

corphealth

I have a spreadsheet that I need to add conditional
formatting to and have not been able to get this to work
correctly. I need to flag decrease in revenues after it
has dropped consecutively for 3 months and would like to
have if possible this highlight with different color for
each of those three months also if possible and then as
revenues climb goes back to black text or no background.

The pivot report is setup like follows:
colum a
Member Name Month year
 
C

corphealth

Power failure and message sent without finishing sample of
table
-----Original Message-----
I have a spreadsheet that I need to add conditional
formatting to and have not been able to get this to work
correctly. I need to flag decrease in revenues after it
has dropped consecutively for 3 months and would like to
have if possible this highlight with different color for
each of those three months also if possible and then as
revenues climb goes back to black text or no background.

The pivot report is setup like follows:
colum a column b c d e and so on
Member Name Month year
.name 1/4/04 2/4/04 3/4/04 4/4/04 and so on
$65,044 $63,000 $32,000 $63,000
Click to expand...

This is the sample of the layout, any assistance with
formula or conditional formatting will be appreciated.
 
F

Frank Kabel

Hi
try the following:
- select cell D2:X2 (so starting with the third month value)
- in the conditional format dialog enter the following formula:
=(C2<B2)*(D2<C2)
- choose a format
 
C

corphealth

This report currently has rows 5 through 778, how would I
write this formula to work for all rows?
 
Top