3 Replies Latest reply: Jan 14, 2014 5:54 PM by Barry
Solar Expert Level 1 (0 points)

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
  • Wayne Contello Level 6 (17,494 points)

    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.

  • Solar Expert Level 1 (0 points)

    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

  • Barry Level 7 (29,914 points)

    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:

    Screen Shot 2014-01-14 at 5.41.38 PM.png

    Checked:

    Screen Shot 2014-01-14 at 5.41.03 PM.png

    Cell B2 contains the formula shown above the first image.

     

    Regards,

    Barry

     

    Victorian piano image from The Graphics Fairy