I have set up some conditional formatting that does want I want it to do in
terms of directions of trends up/no change/down using the three color arrow
icon set. However, the up arrow is green and in the situation that I am
trying to show, up is not good, it is bad so I want the arrow to be red
instead of green. I tried the reverse icon order but of course this changes
the green up arrow to a red down arrow, This is not what i want to show. Is
there a way to use VBA or any hidden tricks in Excel to do this other than
using the grayscale arrows? I am using Excel 2007. thanks for any
assistance.

Mark