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.
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.
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
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
Image pop-up menu in Numbers