As the title states, I am trying to set conditional formatting colours for multiple checkboxes. My table set-up is currently:
- Column 1 (Checkbox)
- Column 2 (Checkbox)
- Column 3 (Checkbox)
I’d like to write an if-statement. If all these columns are checked, then the colour changes to grey text. If not, then these columns stay the same. In terms of formula, I was only able to write the first part with a boolean value:
if (column-1 && column-2 && column-3 = true, ifTrue, ifFalse)
I’d like to ask for help for the conditions ifTrue and ifFalse. ifTrue, what would I use to change the colour to grey? And ifFalse, how would I be able to leave the current colour as it is?
If I’m missing something, please let me know. I just thought to post this as there might be other curious Codans on the same problem.