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

[kingCobra]

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!

[andreas_lds]

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.

[Reeza]

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!

---