Conditional Formatting to show trends

[hawkfan1]

I have a table that has several values for each month regarding each LOB. I am trying to show the trend over the months by using conditional formatting. Does anyone know what formula I would need to do this? Example is if A1 is 5 and B1 is 7 I would like to show that as a green cell or having the up arrow icon, however, if C1 is 4 I would like to show that cell in a different color or with a down arrow.......if they remain the same, another color or an arrow pointing sideways. Any help would be greatly appreciated.

Thanks

 

[HalfAce]

Here are a few ideas.
One, for the formula, you could try something like this: (In say, C1?)
= IF (B1 = A1, CHAR(27) & CHAR(26), IF (B1 < A1, "down", CHAR(24)))

If you want to CF that cell, here's what I did:
First condition: Formula Is =B1 =A1 (and format to suit)
Second Condition: Formula Is =B1 > A1 (and format to suit)
Third Condition: Formula Is =B1<a1<a1 (and="" format="" to="" suit)
< A1
That help at all?

EDIT:
For some reason these formulas won't post correctly so I've added some spaces in them.</a1<a1>

 

[hawkfan1]

yes, that does help. Is there a way to copy conditional formatting from cell to cell or do I have to create it in each cell?

 

[HalfAce]

Sorry for the delay...
Yes, you can simply copy & paste the conditionally formatted cell(s) and paste anywhere you like. But you have to make sure your CF formula(s) are using relative cell references and not absolute. (ie, no $ characters in the formula)

That help?