Change Color of Data

[tracycrown]

Dear Sir

Please advise how to change the color of data from black into red if Data < Min or Data > Max.

Thanks you so much

Tracy

[Gysbert_Wassenaar · Accepted solution]

Click on the + in front of the expression on the Expressions tab, choose Text color and enter an expression to calculate the color: if(sum(Data)<only(Min) or sum(Data)>only(Max),lightred()).

[tracycrown]

Dear  Gysbert Wassenaar

Very good, thank you very much for your quick response.

Please advise how to make lightred to darkred and how to change the background to yellow color ?. Can you show me how to use colormix2(Data,red(),yellow()).

Thank you

Tracy

[Gysbert_Wassenaar]

Replace lightred() with red() to get dark red.

See this video for how to use the ColorMix wizard:

[tracycrown]

Dear Gysbert Wassenaar

Thank you very much for your help.

Tracy