Conditional formatting when checkbox checked

numbers

I am trying to make conditional highlighting accross whole row when a checkbox is checked. I found a tutorial to make this happen, but it doesn't work for me. If you know a better way to do this, please show me how.

At this moment I am trying to use formula from the tutorial:

enter image description here

Where A3 is the checkbox. When I check/uncheck the checkbox I see in the bottom statusbar TRUE/FALSE state, but the formula is not working. In the example it's always showing "NOT YO".

Best Answer

If I think what your asking is what I think might work have you selected from the bottom of what you want to the top?

Related Question