Formatting text WITHIN a calculation

[lizzie]

Greetings

I am trying to format the text colour in the following function so that "1st Target" = Orange, "2nd Target" = Blue, "3rd Target" = Purple and "No Target" = Red.

Case (

Nett Sales Less Support ≥ 550000 and Nett Sales Less Support < 750000 ; "1st Target";

Nett Sales Less Support ≥ 750000 and Nett Sales Less Support < 1000000 ; "2nd Target" ;

Nett Sales Less Support ≥ 1000000 ; "3rd Target" ;

"No Target Hit" )

Please could someone help me!

Edited January 17, 2008 by Guest

[Mikhail Edoshin]

Case(

  Nett Sales Less Support < 550000, 

    TextColor( "No Target Hit", RGB( ..., ..., ... ) );

  Nett Sales Less Support < 750000, 

    TextColor( "1st Target", RGB( ..., ..., ... ) );

  Nett Sales Less Support < 1000000, 

    TextColor( "2nd Target", RGB( ..., ..., ... ) );

  // otherwise

    TextColor( "3rd Target", RGB( ..., ..., ... ) ) )

RGB() is a function to define a color value from Red, Green and Blue components. You can look up values of these components in Mac OS color picker.

[Mikhail Edoshin]

Also: in FM 9 you can do this much simpler with conditional formatting.

[lizzie]

Perfect! Love your work!

Thank you so much!

That worked like a dream!