Even though Excel and Tableau are far from the same tool, sometimes you have to find a way to force Tableau to behave in an Excel-like manner. Conditionally changing the background color of text in Excel is very easy but requires a hack in Tableau 10.3. Use my video to learn how to conditionally format the cell background of a text or dimensional value in Tableau. Trust me, this is a time saver!
If you’re interested in Business Intelligence & Tableau subscribe and check out my videos either here on this site or on my Youtube channel.
Hello! Thank you for a great video! I was able to do this successfully, except I cannot get my value to align properly in the middle. It is always right justified. Can you help? If I make the rows skinnier it looks good, but I need them larger to accommodate other values in the table. Thank you.
Hello, I’ve noticed that after changed formatting for multiple columns sql query on database is executed multiple times. For huge tables this solution can degradate performace. I’m using Tableau 2020.1. Nevertheless great post.
Hi Anthony! Thanks for the instructional vids/vizs for Tableau. On the color topic…wondering if you might know of a way to force tb to always use the same color for bar charts that have a TY/LY type when comparing sales by month. So for 2020, TY/LY were green blue. When the start year went to 2021 (using open workbook with “current year”, tb changed TY/LY to orange red in same palette. Ideally, the same colors would be used.
I only want to make the cell a red color if it is null. I can’t seem to make the rest of the columns have no color and I tried to make them white which does not work eithere.