formula question

B

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?
 
M

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
 
B

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)
 
M

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)




.
Click to expand...
 
Top