Jump to content

Value list calculation problem


smiles
 Share

This topic is 5782 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

Hi,

I am looking for a calculation which can change the text colour in my value list. I only have three possible text drop down options to choose from:

If user selects "optionA" from the drop down,then font colour will be red, if he selects "optionB" then the font colour will be blue etc....

I have tried to use the case function in my auto enter calculated value, but no success. Any help gratefully received.

Simon.

Link to comment
Share on other sites

Comment:

You are the Guru of calculations on this forum and can just come out with the must elegant formulas in no time flat. I just wanted to see what he was trying to accomplish to get an idea of what may be wrong. Sometimes, for the inexperienced like me, it is better to have what I did wrong explained or corrected than just give a simple answer.

Truth be told I didn't have the time to start from scratch, because that would have taken time for me whereas you could probably rip the answer off in 2 minutes. This is a compliment to you not a jab.

Al

Link to comment
Share on other sites

  • Newbies

Hi Guys,

Got my auto enter calc sorted: TextField =

Case ( TextField="optionA"; TextColor ( TextField ; RGB ( 0 ; 128 ; 0 ) );

TextField = "optionB";TextColor ( TextField ; RGB ( 255 ; 0 ; 255 ) );

TextField = "optionC"; TextColor ( TextField ; RGB ( 255 ; 102 ; 0 ) ))

optionA - turns the text colour green, optionB turns the colour pink, and optionC to orange.

A little more time at the workings was all that was required. Thanks anyway, Simon.

Link to comment
Share on other sites

This topic is 5782 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.