Table Formatting

[clobo]

Hi,

From the screenshot below, I'd like to highlight the last row red if the value is greater the average of all the rows (i.e. Analysis Dates) above it. Obviously some cells will be red and some wont... the formula will have to be column specific, but I am not sure how to accomplish this. Any suggestions? I just found out how to color code entire rows, but not specific cells.

Thank you,

Calvin

[christine_assaad]

Hi @clobo 

Please check the attached and let me know if it helps. Cheers!

[clobo]

Thank you for this! 

how can I change the color of "x" (only) if x>x_avg and leave everything else to default black?

[christine_assaad · Accepted solution]

Hi @clobo 

You can do it from the Table configuration screen. Hope this helps!