View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] zed127@yahoo.com is offline
external usenet poster
 
Posts: 1
Default Display autoshape with circumstances

Hi, new to the group. I do not know anything about VBA and I am hoping
that someone can help me out, I have not found a way to join multiple
formulas to achieve what I am after.

I have cells A1, B1, C1 and 3 different autoshapes
If cell B1 is < A1 I want to return image 1 (green up arrow, autoshape)
in cell C1
If cell B1 is A1 Iwant to return image 3 (red down arrow, autoshape)
in cell C1
If cell B1 is = A1 I want to return image 2 (yellow left-right arrow,
autoshape) in cell C1

Any ideas or suggestions anyone could offer would be appreciated!

Thanks for your help.