inserting a shape arrow if a cell = a certain value

[mingandmong]

Hi im using excel 2010

In my work book i have a inserted an arrow from the insert shape's ive chosen the block arrows section down arrow 4 & Up arrow 5

is it possible that if cell A1=0 then B1 has the down arrow 4 inserted And if A1 value= 1 then the up arrow 5 would be inserted into B1

it would appear that the shapes are not actually embeded to a cell referance, but are overlayed on cells

i would then copy these columns down

Many thanks

 

[My Aswer Is This]

Conditional Formatting has a Arrow set that may do what you want. Try playing with that.

 

[mingandmong]

Thanks My Answer Is This
The arrows are too small i believe i may have to uses the arrows in wingdings and character code to a cell if no one else comes up with a solution

 

[My Aswer Is This]

When you change the cells font size those arrows get really big.

 

[My Aswer Is This]

In CF you used what is know as Icon sets ?

 

[mingandmong]

yes,
the arrow i need is approx 4cm tall x 1 cm wide

 

[mingandmong]

Hi All
i have managed to get this to work using the name manager
my next question is i cannot select a range do i have to mannualy type in each range and then type the diifernt name change's in the name box to match
i just want to make the formula to look in column "B:B" rather than type out another 500 ranges.. is there an easier way

My 2 picture arrows reside in column "M" the value 0 & 1 reside in Coulmn "N" and the input data into column "B"

Arrow =INDEX('Picture Lookup'!$N$2:$N$3,MATCH('Picture Lookup'!$B$2,'Picture Lookup'!$M$2:$M$3,0))
Arrow_1 =INDEX('Picture Lookup'!$N$2:$N$3,MATCH('Picture Lookup'!$B$3,'Picture Lookup'!$M$2:$M$3,0))
Arrow_2 =INDEX('Picture Lookup'!$N$2:$N$3,MATCH('Picture Lookup'!$B$4,'Picture Lookup'!$M$2:$M$3,0))
Arrow_3 =INDEX('Picture Lookup'!$N$2:$N$3,MATCH('Picture Lookup'!$B$5,'Picture Lookup'!$M$2:$M$3,0))