formula question

[btcdeb]

Is there a formula that can change the color of cells if
revenues drop three months in a row and if so what should
the formula be?

 

[mzehr]

Hi,
Assuming that your data is in row 1, columns A,B,C, with C
being the latest data, Try using conditional formatting in
cell C1 with the "Formula Is"
=IF(AND(C1<B1,B1<A1),1,0)
HTH

 

[Bob Phillips]

Formula only needs

=AND(D1<C1,C1<B1,B1<A1)

you don't need the IF...1,0

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[mzehr]

Thanks for the hint!

-----Original Message-----
Formula only needs

=AND(D1<C1,C1<B1,B1<A1)

you don't need the IF...1,0

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)




.