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.

1 Like
4

I agree. All spreadsheets programs (Sheets, Excel, Calc…) can do this easily, but it’s a pain in Coda.
It would be great to be able to conditionally format the whole table on a cell-by-cell basis.

5

Dear @cblock,

:bulb:I don’t know if you are aware of the recent improvements on filtering and conditional formats

Edit: 4.9.2019 - an update released :bulb:

6

I have just discovered this yesterday, randomly. Thanks for the callout @Jean_Pierre_Traets

This issue is officially RESOLVED.