conditional formatting with pictures

[mrbab7]

hi guys....i',m driving myself a little bit crazy with this one! so i'm turnning to you brainy people, especially as one of my searches brought me back to the forum, where @Damon Ostrander had helped someone out with something fairly similar by using a VBA code (which i am completely clueless with) - Conditional Formatting - Use Graphic / Picture?

wondering if someone could get me to the desired result

I've placed all the arrows in the cells they are required for and they are all named arrowa, arrowb, etc with the ones in the 'potential' column are the same with a p added to the end, so arrowap.
the data is on sheet2 (as per pic), i have both the score and the letter, but would assume the letter would be the easier reference to use.

i need all the arrows to disappear if the relevant letter isn't listed in F8 & F9

please help, I've tried loads of different solutions today and now i'm close to throwing the laptop out the window

thanks for any help in advance.

 

[mrbab7]

Energy table.xlsm
	C
28	Exceptional
Sheet1

Cells with Data Validation
Cell	Allow	Criteria
C28:C32	List	Inadequate,In need of improvement,Average,Above average,Exceptional

 

[mrbab7]

link to doc

 

[mrbab7]

I've attached the doc on the last post, as the xl2bb thing didn't seem to come out too well....

I had an attempt at editing the VBA code myself and it now hides the arrows in the current section, but it doesn't the graphic, it just lists "arrowa" and then if you bring the rating down, the others don't show at all?

also when that sides figured, need to do the same for the potential one, but don't understand VBA at all, so no idea how to run both instructions.


please if anyone can help, it would be greatly appreciated

thanks

 

[Jaafar Tribak]

link to doc

Where is the Download button ?!

 

[mrbab7]

Where is the Download button ?!

link to doc

 

[Jaafar Tribak]

link to doc

I meant that when clicking on that link, I see no button or link for downloading the excel file. There is a button that reads *download* but it takes you to another page and asks for registration. Super complicated.

 

[mrbab7]

I meant that when clicking on that link, I see no button or link for downloading the excel file. There is a button that reads *download* but it takes you to another page and asks for registration. Super complicated.

it just a file share page, thought you'd be able to grab it.

try this one

Loading Google Sheets

 

[mrbab7]

it just a file share page, thought you'd be able to grab it.

try this one

Loading Google Sheets

doesn't look like that will work either as directs to google sheets :/

let me try another file sharing option

 

[mrbab7]

Energy table.xlsm