C
corphealth
I need to have the spreadsheet I'm working on reflect if
clients revenues or collections have dropped for 3
consecutive months in a row. I need to somehow flag this
where executives can see when there is a downward trend.
The columns that these stats are in are G & H and the way
they'd set this spreadsheet up is each month goes down the
spreadsheet
example is:
client name month/04 sales rep and so on
John Doe may-04 brad $39330.00
goes down with all may stats and few lines are skipped
before beginning next month and so on.
John Doe june-04 brad etc.
I've tried the conditional formatting, but everything I've
tried needs a beginning $amount, I just be able to flag a
decrease in general when it's reached the 3rd month.
Thanks for any help anyone can provide.
clients revenues or collections have dropped for 3
consecutive months in a row. I need to somehow flag this
where executives can see when there is a downward trend.
The columns that these stats are in are G & H and the way
they'd set this spreadsheet up is each month goes down the
spreadsheet
example is:
client name month/04 sales rep and so on
John Doe may-04 brad $39330.00
goes down with all may stats and few lines are skipped
before beginning next month and so on.
John Doe june-04 brad etc.
I've tried the conditional formatting, but everything I've
tried needs a beginning $amount, I just be able to flag a
decrease in general when it's reached the 3rd month.
Thanks for any help anyone can provide.