4 Replies Latest reply on Jan 31, 2018 12:54 PM by Deepak Rai

Cell formatting

Nagesh CL Jan 31, 2018 9:37 AM

Hi,

I have a requirement in tableau, where in i have to compare values between two cells and color code based on comparision. Something like the below: -

If column1 value matches column2 then format (Either fill color or font color) the cell in green else red.

Thanks.

1. Re: Cell formatting

Deepak Rai Jan 31, 2018 9:43 AM (in response to Nagesh CL)
Here it Is:

Thanks
Deepak

red green.twbx 11.5 KB
Like Show 0 Likes(0)

Actions
2. Re: Cell formatting

Nagesh CL Jan 31, 2018 10:08 AM (in response to Deepak Rai)

Hi Deepak,
Could you please share the workbook with me?
Thanks.
Like Show 0 Likes(0)

Actions
3. Re: Cell formatting

Deepak Rai Jan 31, 2018 10:18 AM (in response to Nagesh CL)

Hi Nagesh
Workbook is already attached. Please go to main thread, not in email. and if it Helps, Please mark it Helpful and CORRECT to close Thread.
Thanks
Deepak
1 of 1 people found this helpful
Like Show 0 Likes(0)

Actions
4. Re: Cell formatting

Nagesh CL Jan 31, 2018 12:41 PM (in response to Deepak Rai)

Thanks Deepak. This worked as expected.
I have a little enhancement to this one.

Compare multiple set of columns like above. I created multiple calculated columns like in the workbook attached by you. But the thing is the alignment. I am not able to align it in the form which is in the screenshot. Alignment meaning the order of columns which is required.
Like Show 0 Likes(0)

Actions
5. Re: Cell formatting

Deepak Rai Jan 31, 2018 12:54 PM (in response to Nagesh CL)

Formatting Takes care of alignment. You can Format each Measure individually. Click Format then from Choices Select Alignment and Select what ever is needed.
Like Show 0 Likes(0)

Actions

Tableau Community