My apologies if I become slightly annoying in the next couple of weeks, but after two years of learning Excel VBA I've come to the realization that I do not know JACK about excel.
My question...
Lets say I have two columns A & B and I'd like to indicate the direction (More/Less) Column B moved from column A. If the change was positive between A and B I'd like to have an UP arrow on the right side of column B and a DOWN arrow if the change was negative.
Is this something that would be accomplished with Conditional Formating and Shape insertion? I don't want to change the arrow manually when the data changes. Kind of like you see in some accounting software.
Thanks.
My question...
Lets say I have two columns A & B and I'd like to indicate the direction (More/Less) Column B moved from column A. If the change was positive between A and B I'd like to have an UP arrow on the right side of column B and a DOWN arrow if the change was negative.
Is this something that would be accomplished with Conditional Formating and Shape insertion? I don't want to change the arrow manually when the data changes. Kind of like you see in some accounting software.
Thanks.