Colour code calc

[Oyseka]

I have to produce a solution for production statistics with a visual differentiation between the three classes of results which are >5% below target, >5% above target and within 5% of target. As these results would be a calculation of a number against a pre set target, how can I combine this calc with FM7's ability to colour text.

Chris

[comment]

TextColor ( result ;

Case (

result/target < 0.95 ; RGB ( 0 ; 255 ; 0 ) ;

result/target > 1.05 ; RGB ( 255 ; 0 ; 0 ) ;

RGB ( 0 ; 0 ; 255 )

) )

Set result to Text, of course.