additional formula ?

C

corphealth

How do I write the formula mentioned below to encompass
rows 5 - 778 so that it takes care of all at once and then
of course this expans on a monthly basis both across
columns as new months are included and then down rows as
new clients are included.

Thanks.


select cell D2:X2 (so starting with the third month
value)
 
C

corphealth

I've tried this using all columns and have used this for
one row that does have drops each month for three
consecutive months, but no change takes place.

I used the formula like you had below but extended it to
also encompass columns c:i which include Jan - July numbers

so I did the following which I've obviously made a mistake
on =(d5<c5)*(e5<d5)*(f5<e5)*(g5<f5)*(h5<g5)*(i5<h5) and
then added the formatting color that would be applied and
nothing happened. I'm new to this as you can tell.

Thanks
 
Top