Simple conditioning formatting for a table

#1

Hi,

I want to color the cell RED if the value is 0 and GREEN if the value is 1. Currently, I’m doing it like this:
[column1]=0, RED, APPLIES FORMAT RULE TO column1
[column1]=1, GREEN, APPLIES FORMAT RULE TO column1
[column2]=0, RED, APPLIES FORMAT RULE TO column2
[column2]=1, GREEN, APPLIES FORMAT RULE TO column2

I have many columns. Is there an easier way to do this?

Thank you.

#2

You could do it a bit easier. In your example you could say:

[column1]=0, RED, APPLIES FORMAT RULE TO column1 & column 2 (or all columns)
[column1]=1, GREEN, APPLIES FORMAT RULE TO column1 & column 2 (or all columns)

Then you reduce your manual work massively.

For more complex setups I could not find easier ways too unfortunately…

#3

The above doesn’t work because if one cell is green, APPLIES TO ALL COLUMNS makes the WHOLE ROW green.

There should be a cell variable so that the conditional formatting can be done easily.