How to set conditional colour formatting for multiple checkbox columns?

#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.

1 Like
#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!

1 Like
#3

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

2 Likes
#4

Hey @Scott_Collier-Weir - what did you check for the Apply to field? I wish to have a similar formula, but with OR instead of AND, while marking only the row / column combination that matches the rule.

For your screenshot and my formula, this would mean something like:

  • first row - all grayed out
  • second row - only the first two are greyed, the last one is not
  • third row - only the first one is greyed, the last two are not.

Appreciate it!

#5

Ahhh yours is a different use case then. You would need to create one conditional format rile per column

And each rule would just turn that individual cell Gray if the checkbox is checked.

#6

That sucks :frowning_face: I have 53 columns, I though there might be a simpler way.