Excel Experts! Is something like this possible?

[TheFuteballer]

I'm just curious as to this is a function in Excel 2007 as I know for sure it's coming in 2010...

If you're comparing two cells in excel and you graphically represent the difference by an arrow? (i.e. if cell 1 is "5" and cell 2 is "7" and you're running a comparison formula on them, it would show an arrow pointing up)

Or if not an arrow, is this a good way I can graphically express something like this function in excel?

[llau]

Yes, this can be done in Excel 2007.

For example, say you have 5 in A2 and 7 in B2.
Now the comparison result is stored at C2 using "Conditional Formatting".
Enter the following formula at C2:=IF(A2=B2,1,0)

To add "Conditional Formatting" at C2:
- select C2
- Click "Styles" > "Conditional Formatting" > "Manage Rules"
- Click "New Rule"
- For the "Format Style", select "Icon Sets"
- For the "Icon Style", select "3 Arrows (Colored)"
- Then for the first set, enter ">=" , Value="1" and Type="Number"
for the second set, enter ">=", value='0" and Type="Number"
- Now you should see "Green Arrow" at C2.

If you change B2=5 , then C2 should be "Yellow Arrow" with 0.

Hope this helps.

[TheFuteballer]

Perfect! First time I've used conditional formatting, going to have to look deeper into it thanks!