Color Tabulate report based on other column value

[#1]

Hi,

I would like to Color Tabulate report based on other column value (if needed result is higher then the second column then color it)

or maybe create the Tabulate and then convert it to data table or summery table and color it.

is there a way to do so?

appreciate your support on this

[#2]

I think you have to do this with scripting and it will be easiest to first run Tabulate (or maybe Summary is even easier), then get rows which you want to color and then color those rows in specific columns

Names Default To Here(1);
dt = Open("$SAMPLE_DATA/Big Class.jmp");

// get rows to color
rows_to_color = dt << Get Rows Where(:height >= 65);

// color specific rows (rows_to_color) in specific column ("Age")
Column(dt, "Age") << Color Cells("Red", rows_to_color);

Edit: Here are some older topics about coloring cells Conditional formatting in a data table , Conditional formatting in a data table