Image pop-up menu in Numbers

Can I have an image conditionally appear in a cell?

Would like to have a pop-up menu where a different image will display in a cell, depending on the pop-up option selected.

Posted on Dec 27, 2020 4:36 AM

Reply
Question marked as Top-ranking reply

Posted on Dec 27, 2020 12:01 PM

No.


Images placed in Numbers cells are seen as "image fill", which is a Format, Formulas, including those triggered by pop-up menu items, can change the content of their cells, but not the format.


That said, you can accomplish a similar effect by making a cell formatted with image fill of a specific image become visible when an associated popup menu contains a specific value by using a formula in an associated cell. Heres an example:


There are two pairs of tables here. The left side member of each pair contains a header row with the text "Select" and a single ody cell (A2) containing a pop-up menu. The upper table shows the pop-up st to "purple"; the one below is currently hidden behind the open menu, which is set to 'blue.'


Each of the tables on the right has one header row and one body row for each item on the associated pop-up menu.


The filter rule shown to the right of the tables is set to Show only the header row and any rows where column B contains the text "show."

The visible column above is column C. Columns A and B are hidden when the table is in use, but shown below:



Column A of the results table contains the list of items in the pop-up menu.

Column B contains the formula shown below the tables, entered as shown in B2, then filled down to the last row of the table.

The IF statement puts the the text "show" in its cell if the text in that row of column A contains the selected word in the pop-up menu cell (A2 of Table 1-1) and a null string if it does not match the menu item.


With the Filter checkbox unchecked (as in the example above, the result table will show all rows, as in the middle image above.


Regards,

Barry

1 reply
Question marked as Top-ranking reply

Dec 27, 2020 12:01 PM in response to SailJapan

No.


Images placed in Numbers cells are seen as "image fill", which is a Format, Formulas, including those triggered by pop-up menu items, can change the content of their cells, but not the format.


That said, you can accomplish a similar effect by making a cell formatted with image fill of a specific image become visible when an associated popup menu contains a specific value by using a formula in an associated cell. Heres an example:


There are two pairs of tables here. The left side member of each pair contains a header row with the text "Select" and a single ody cell (A2) containing a pop-up menu. The upper table shows the pop-up st to "purple"; the one below is currently hidden behind the open menu, which is set to 'blue.'


Each of the tables on the right has one header row and one body row for each item on the associated pop-up menu.


The filter rule shown to the right of the tables is set to Show only the header row and any rows where column B contains the text "show."

The visible column above is column C. Columns A and B are hidden when the table is in use, but shown below:



Column A of the results table contains the list of items in the pop-up menu.

Column B contains the formula shown below the tables, entered as shown in B2, then filled down to the last row of the table.

The IF statement puts the the text "show" in its cell if the text in that row of column A contains the selected word in the pop-up menu cell (A2 of Table 1-1) and a null string if it does not match the menu item.


With the Filter checkbox unchecked (as in the example above, the result table will show all rows, as in the middle image above.


Regards,

Barry

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Image pop-up menu in Numbers

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.