How to change Text Color in table, but not Cell Color

hamza_123 · March 2020

I want to change text color in a cell in a table based on a certain condition. But when I go to color option, it colors the whole cell and not just the text.

Can anyone tell me how to do this?

user11139 · March 2020

Hi @Neeti,

I tried using your piece of code. In my case, I am using a pivot tabl and not a table. Your code seems to color the background in a table, but we are interested in coloring the text only, not the background.

Do you know what parameter it is?

Moreover, did you try it for a pivot table or a regular table?

Thanks!

Neeti · March 2020

HI,

You can try color rules also, which will either change cell color or row color, based on your selection in color rule window. I have tried this on both pivot and normal table. Also, SUmo table will have more effective color rule implementation. Did you try sumo tables?

Thanks,

Neeti

user097712 · December 2020

Hi! I am using this to color a cell for a Mega Table:

CONCAT('<div style="background-color:#69ff96; width: 100%; height:100%; margin:-20px; padding:20px"><a href="#">',CONCAT(`Month Data.ABSENTEEISM`, '%',' ', '(', CASE WHEN `Variance ABSENTEEISM` > 0 THEN '+' ELSE '' END , SUBSTRING(`Variance ABSENTEEISM`, 1, 5),'%', ')'), '</a></div>')

The problem is that, no matter the number I change in the div, I always see a light blue value.

Basically I need to green and red colours , so I can paint the value based on a condition.

jaeW_at_Onyx · December 2020

AFAIK, Mega tables do not support HTML formatting. HTML tables do, but they don't have all the functionality of Mega Tables (on the fly sorting or scrolling).

Charting

Charting

How to change Text Color in table, but not Cell Color

Welcome!

Comments

Welcome!

Quick Links

Categories