formula question

  • Thread starter Thread starter dolinger
  • Start date Start date
D

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.
 
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
 
Back
Top