How do I conditionally format rows in a table based on the value of a single field in the row?

[dbfg]

Hi All,

As my subject says, I want to use conditional formatting on a table in my sheet. The table includes lots of information in many rows and columns. One of the columns is a delivery status column, this column includes three states of delivery: EARLY, LATE and ON TIME. Basically what I want to do is have the entire row change colour based on the value of this column. So for example:

1. If the field says LATE, then the whole row should be red.
2. If the field says EARLY then the whole row should be orange.
3. if the field says ON TIME, then the whole row should be green.

How would I achieve this?

Thanks in advance.

[Mauritz_SA · Accepted solution]

Hi there

I think you will have to put the following formula into the Background color expression field of every single column (dimensions and measures):

If([Delivery Status] = 'LATE',Red(),
If([Delivery Status] = 'ON TIME',Green(),
rgb(244, 170, 66)))

Good luck.

Regards,

Mauritz

[Aza]

Hi,

Please help me. How to fill the cell based on their pertentage value like below progress field.