How to use a tick box to change a field’s colour in Numbers 09 on MacOS high sierra
Thanks all for considering this question.
i need to create a tick box that will allow a cell (or preferably row) to change colour if true.
im having a lot of trouble and am trying to use a tick box to create a true value, then intended to use an IF statement to manipulate the formatting of a row based on the outcome.
i am relatively new to numbers and have struggled to find a relevant part of the numbers doc that does more than tell you how to create the tick box. I’d like to understand How to make the tick box a functional value.
many thanks in advance.
iMac (Retina 5K, 27-inch, Late 2014), macOS High Sierra (10.13.2), Numbers