How to change Text Color in table, but not Cell Color
Comments
-
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!0 -
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
0 -
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.
0 -
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).
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0
Categories
- 10.5K All Categories
- 5 Connect
- 915 Connectors
- 250 Workbench
- 459 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 476 Datasets
- 186 Visualize
- 250 Beast Mode
- 2.1K Charting
- 11 Variables
- 16 Automate
- 354 APIs & Domo Developer
- 88 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 245 Distribute
- 62 Domo Everywhere
- 242 Scheduled Reports
- 20 Manage
- 41 Governance & Security
- 170 Product Ideas
- 1.2K Ideas Exchange
- 10 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive