Good evening guys & gals,
(beforehand, please excuse my bad english, but expected this to be the sub with the most knowledge)
Since two days I’m getting more and more desperate and now finally decided to register.
Due to a new job I had to start with spreadsheet editors 1,5 week ago & starting to realize why people are hyped and say things like “powerful tool”.
But today I faced a problem I can’t wrap my head around…
I’m trying make a dropdown (Data → Validity) with some personal .pngs I made.
Via Cell Range didn’t work. I thought it was because the pictures weren’t properly connected to the cell, 'cause when I deleted the cells with DEL the pictures were still there, but I guess reason is that my pictures are not part of the internal system, right?
I also wanted to swap the Arrows, Ratings etc.-symbols (Conditional - > Icon set) with my own symbols. This way I could’ve gone by using the value of a word in the dropdown which then gets replaced by one of my icons.
I also tried special characters, but… colour…
I ended up at =IFERROR VLOOKUP to replace a word in the dropdown with one of the pictures in another cell… and then my head exploded.
Am I even on the right path?
Seems like I’m in a loop. Hopefully someone can help me out over here.
TLDR: I’m trying Data → Validity → Show custom .png icons in dropdown menu
Kind regards,
A