Matthew Hile
Top achievements
Rank 1
Rank 1
Matthew Hile
asked on 26 Jan 2009, 02:06 PM
I am trying to do a couple of things with conditional formatting.
1. Create a conditional format based on the returned valued from a user defined function.
I have created a user defined function that returns the text "low" , "moderate", and "high" and is shown in a text box. I would like to make the text box bold or bold italic based on the value returned. Can this be done with the conditional formatting system?
2. I will have a number of text boxes that will have the same conditional format (e.g., if value is > 5 make bold). How can I use the same formatting rules in different text boxes?
Thanks,
Matthew
(update - Would styles be the way to do these things?)
1. Create a conditional format based on the returned valued from a user defined function.
I have created a user defined function that returns the text "low" , "moderate", and "high" and is shown in a text box. I would like to make the text box bold or bold italic based on the value returned. Can this be done with the conditional formatting system?
2. I will have a number of text boxes that will have the same conditional format (e.g., if value is > 5 make bold). How can I use the same formatting rules in different text boxes?
Thanks,
Matthew
(update - Would styles be the way to do these things?)
1 Answer, 1 is accepted
0
Massimiliano Bassili
Top achievements
Rank 1
Rank 1
answered on 29 Jan 2009, 06:37 PM
You can use the detail's section ItemDataBinding/Bound events and check for the Value/Text received and perform your last minute formatting and styling. I haven't thought of styling for such purpose, but it might just work. You can check the Styling section in the help, if you decide to give it a spin. And do share your finding :)