formula question

[dolinger]

Is there a formula that can change the color or at least
bold cells when revenue drops 3 months in a row and if so,
can you give me an example of what the formula should be.

 

[Juan Sanchez]

Take a look to help for Conditional Formating...

Regards
JS

 

[Max]

Assume you have the following values in A1:A7

3
2
1
1
2
1
0

Select col A

Click Format > Conditional Formatting

Make the settings under "Condition 1":
Formula Is | =AND(A2<A1,A3<A2)

Click Format button > Format to taste
(E.g.: Red & bold in Font tab, yellow in Patterns tab) > OK

Click OK

For the sample values in A1:A7 above
what you formatted would be highlighted in A1 and A5