I have a requirement which needs to be color code dimension Project Name cell based on a Project KPI condition as shown below. I tried creating two different sheets one for Project Name color code and one for Project KPI and Task KPI and then combining both of them in dashboard but the issue i am facing is multiple scroll bars are showing up on the dashboard which users should scroll both the sheets at the same time and this is not a good solution. Is there a better solution to color code Project Name cell based on Project KPI condition?
Tableau isn't really designed as a crosstab tool, so the formatting in your screenshot would be pretty difficult to replicate exactly.
However, try out this article http://kb.tableau.com/articles/howto/conditionally-color-rows-in-crosstab to achieve the desired result.