Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
How would I achieve this?
Thanks in advance.
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
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
Hi,
Please help me. How to fill the cell based on their pertentage value like below progress field.