topic ODS Excel - How to color code rows based on value of a variable in ODS and Base Reporting

ODS Excel - How to color code rows based on value of a variable

kingCobra — Mon, 20 Dec 2021 08:35:52 GMT

Hello,

I need to produce excel report with color coded rows based on values of a variable (Response: poor=red, bad= amber, good= green, ...so on).

Also, can I do the same thing; but this time instead of entire row, I just want to color code the Response variable only.

How can I do this using ODS Excel?

Thanks!

Re: ODS Excel - How to color code rows based on value of a variable

andreas_lds — Mon, 20 Dec 2021 08:42:20 GMT

There are dozens of topics dealing with your problem, please use the search function. Some paper exist, too, search for "traffic lighting". If you want help in detail, we need the code you use to create the excel-file along with data in usable form.

Re: ODS Excel - How to color code rows based on value of a variable

Reeza — Mon, 20 Dec 2021 16:55:45 GMT

This paper covers the topic quite well

https://www.lexjansen.com/wuss/2006/tutorials/TUT-Carpenter.pdf

@kingCobra wrote:

Hello,

I need to produce excel report with color coded rows based on values of a variable (Response: poor=red, bad= amber, good= green, ...so on).

Also, can I do the same thing; but this time instead of entire row, I just want to color code the Response variable only.

How can I do this using ODS Excel?

Thanks!