How do I apply a conditional format or set of formats to highlight revenues
in a table when they drop for at least three consecutive months in a row. I
do not want any cells to be highlighted unless they are down 3 or more months
in a row and the way I'd had it setup was the cell was yellow first month
drop, second orange and third month down was red, but cells that we down even
1 month would be changed to yellow etc. I would like to set this up where it
I wouldn't have to do anything except update from the main data sheet and all
the conditional formats would be in place. It's not working the way I'd
setup.

a sample of what it looks like is below and it just continues on through the
months like this: in this case the 1-3 cells would need to be highlighted but
drops off and Aprils would not as numbers are back up.

Jan Feb March April
$39,853.00 $38,644.00 $32,374.00 $43,469.00