nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Color Cells based on formula result and display using tabulate.

ENTHU

I am using tabulate command to display data from a table along with a graph.I have colored the cells in the data table based on a condition.

Lets say if temperature < 5 color = red, 10<temperature<20 color = blue etc.

I am then using tabulate function to create table from this.But the cell color doesnt seem to show up in the final output table.

Accepted answers

All comments

txnelson

The Tabulate Platform does not support cell color. The displayed output from Tabulate is not a data table. However, you can have the platform generate a data table from the displayed output, and then you can color those cells. Look under the red triangle for the "Make into data table" option.

ENTHU

Thanks!

gzmorgan0

Just a quick note on several alternatives:

Use Table Summary and color rows
From the Tabulate menu, select Make Into Data Table and color that display
Write a script to make a custom display table.
If possible, create a graph to represent the table. If it is complex, this is likely not feasible. Below is a simple example. The Graph Builder label is Percent of Total. Note that the bar colors are custom: 12-13 Blue, 14-16 Green, 17+ Red.

ENTHU

This is helpful but I have a 20x20 data table.I have to loop through each cell, check the value and color it accordingly.

Eg : I have age1 - age10 columns.I need to color all cells withe age <20 as blue.

How can I do this?