Creating Excel Style Conditional Formatting in Tableau - Tableau in Two Minutes
How to Create Excel-style conditional formatting in Tableau. It's a little bit of a pain, but it's the only way you can have two columns colored or with shapes driven by different values.
If you're trying to recreate a report from Excel, this technique is invaluable, since there are few other ways to get measure values to format differently from one another. Also, the fundamentals of this little hack - sneaky calculated fields and dummy fields - can help you get around other Tableau restrictions or idiosyncrasies as you stumble across them. :-)