How to set conditional colour formatting for multiple checkbox columns?

Ask the Community
#1

Hi all,

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.

#2

Hey there!

Is this what you are looking for?

image
image994×324 39.3 KB

When you write a conditional format like that you don’t need to use the if statement. The conditional formats are essentially reading your statement as true/false and formatting when finding true

Hopefully that helps!

#3

Sorted! A lot easier and straightforward than what I was trying to do. Thanks Scott :slight_smile:

1 Like