I have a data set and I want to colour code the variance. If it's within |0.02| and 0, then highlight the cell (or text) green, and else in red.
I've attached an example of what I would like.
So the ones circled in green are what I want to highlight in green, and so on.
I looked up conditional formatting and found something similar that involves 'mark', 'bit colour', etc. but I have no idea what I'm supposed to do.
If not, I guess I will have to do it the old fashion way and export to excel and go from there. >:(
So with the help of this thread, now I'm able to colour code all the columns with variance greater than 2%; however, it's affecting my other measure values like paid, difference, etc.
Is there a way to only limit the colour marks to just the variance row?
See http://public.tableausoftware.com/views/conditionalformattingv4/Introduction for a few techniques, also Joe Mako covered another technique in this Think Data Thursday talk: http://community.tableau.com/thread/126855