Numbers 09 - is there a way to hide/show photos with a tick box or drop down?

Question

Level 1

9 points

Numbers 09 - is there a way to hide/show photos with a tick box or drop down?

Hello  world. First off, I appologise if this is a duplicate post. I thought I submitted, but couldnt find my post anywhere, so here goes.

For my business, I use a fairly advanced template in Numbers 09 to create proposals for customers. I'd like to take it to the next level. Is there a way using a drop down menu, tick box, or exact lookup to hide/show the appropriate image? If so, what are the steps involved? Thank you in advance for your help.

By the way, I'm also looking for a freelance Numbers geniuss to help with our latest proposal template build. We are in the Cupertino, CA area just a few minutes from  headquarters.

Thanks!

Ash

MacBook Air (13-inch Mid 2012), OS X Mountain Lion (10.8.5), NUmbers 09

Posted on Jan 14, 2014 3:01 PM

Reply

Answer 1

Jan 14, 2014 3:23 PM in response to Solar Expert

Ash,

Numbers only stores images (when pasted into a table) as a cell back ground.

The cell background is not a retrievable item. You can provide feedback to Apple. You may be able to develope an apple script to retrieve images so long as you can use the previous version of Numbers.

Reply

Answer 2

Solar Expert Author

Level 1

9 points

Jan 14, 2014 3:44 PM in response to Wayne Contello

Thanks Wayne, the apple script is an interesting idea. Unfortunately, no one on my team has experience with it. I'm often surprised at the limitations of numbers given it's many awesome features. It could be as simple as a "bring to front" layering comand if there was such a thing. Any other ideas, anyone?

Ash

Reply

Answer 3

Barry

Level 9

59,861 points

Jan 14, 2014 5:54 PM in response to Solar Expert

Hi Ash,

Here's an example you might find useful. It uses an image fill in the cell, and conditional formatting to replace the image with white fill (and text) when a specified condition is met. The text meeting the condition is here controlled by the state of the checkbox in the cell to the left of the one containnig the image fill.

Unchecked:

Checked:

Cell B2 contains the formula shown above the first image.

Regards,

Barry

Victorian piano image from The Graphics Fairy

Reply