Conditionally display an image in a cell

user_9205480 0
Viewed 35

I have a column of checkboxes and when I query this column it returns TRUE/FALSE. Could I display something other than TRUE/FALSE using conditional formatting? i.e. an image of a checkmark or 'X'

An alternative idea:

Use a helper column along with an if statement to display what I'd like, and query that helper column instead. Would the character/image be processed by query?

conditional-formatting google-query-language google-sheets-formula google-sheets checkbox
1 Answers

value of the checkbox by default is TRUE/FALSE but it can be custom:

enter image description here

formulas are not permitted as custom ticked/unticked values:

enter image description here

with the conditional formatting you can only paint the background of the checkbox or the checkbox itself to a color of your wish

enter image description here

QUERY is not able to read images:

enter image description here

you can use FILTER:

enter image description here

to assign image you can use VLOOKUP:

=FILTER({IFNA(VLOOKUP(A15:A18, G15:H, 2, 0)), B15:B18}, A15:A18="yes")

enter image description here

user_56326290
Related