Conditional Formatting and arrow icon sets
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 |
All times are GMT +1. The time now is 04:19 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com