How to change Text Color in table, but not Cell Color
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?
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?
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
- 7.7K All Categories
- 918 Connectors
- 242 Workbench
- 476 Transform
- 1.8K Magic ETL
- 60 SQL DataFlows
- 446 Datasets
- 35 Visualize
- 198 Beast Mode
- 2K Charting
- 8 Variables
- 16 Cards, Dashboards, Stories
- 1 Automate
- 348 APIs & Domo Developer
- 82 Apps
- 14 Predict
- 3 Jupyter Workspaces
- 11 R & Python Tiles
- 241 Distribute
- 59 Domo Everywhere
- 241 Scheduled Reports
- 15 Manage
- 36 Governance & Security
- 23 Product Ideas
- 1.1K Ideas Exchange
- Community Forums
- 15 Getting Started
- 1 Community Member Introductions
- 49 Community News
- 18 Event Recordings
- 579 日本支部