3 Replies Latest reply on Apr 17, 2014 12:32 PM by philmodjunk

    Color coding a field



      Color coding a field


           I am trying to make a container field change color with calculation (I hope I said that right, I am still a beginner) the problem I am having is that I cannot figure out how to call the color of the field out to make it changeable. This is what I have tried 

           I made a Priority data field and set a calculation to it. 

           If ( (CurrentDate-StartDate) > 30 ; RGB ( 0 ; 0 ; 0) ; RGB ( 0 ; 0 ; 33 ))

           I just need the colors to toggle between white and red. I want to add more colors later ( I know I cannot with this if statement) but I am taking baby steps at this. 

        • 1. Re: Color coding a field

               Why use a container field for this?

               The RGB function must be used with the TextColor function to specify text color. It can't to my knowledge be used to change the fill color of a field.

               But a conditional format expression can be specified to give any type of of field, container or otherwise, different fill colors. But an image inserted into a container field will conceal much of the fill color--possibly all of it, produced by the container field.

          • 2. Re: Color coding a field

                 I am not using images and you just explained so much. Can I ask how you call the FILL colors out to be change in the expression or equation?

            • 3. Re: Color coding a field

                   You don't.

                   Place a field on your layout.

                   Right click it and select Conditional formatting....

                   In the dialog that appears enter an expression that evaluates as True or False. ( (CurrentDate-StartDate) > 30 ) Use the controls in the dialog to select the field formatting options--which includes the fill color you want for when the expression is True.