To format a single cell, the data would need to be pivoted. In the current scenario, you can color the entire row as shown below:
Thank you for your reply; however, unfortunately, I cannot pivot my original data due to other sheet requirements/dashboards. I tried implementing the solution here: Conditionally Formatting Cell Background Color | Tableau Software (the "Container" method) but couldn't implement it properly. Any hints on how could I do it?
That's basically using multiple zero value columns and displaying labels. You should try to download the sample workbook they are referring and see how it works.