#Conditional formatting definition code#

To change your rule, click on 'Formatting Rules' in the Analysis>Conditional menu.

#Conditional formatting definition code#

In this case, the field D Dept Code was selected to receive the formatting. If the enrollment of a course is greater or equal to 100, make the text in the selected field turn red. To remove the formatting, complete the same steps to de-select the conditional formatting rule from your chosen content.Д®xample: Courses with 100 or more enrollment Click on the triangle after the 'Formatting Rules' button.ДЈ. Navigate to the Analysis Menu, then the Conditional submenu. Click on the contents of the field that you want to apply your rule to.Дў. Once you're content with the rules, click 'Ok' Apply Your RuleДЎ. To remove a rule from your bundle, click the small black 'x'.Д©. To define more than one rule in the same bundle, click the green '+ Add' and start the process again.ДЁ. Once you're content with your condition or your formula, define the formatting that should appear by clicking the 'Format.' button.Д§. IV) To open up the Formula Editor, click on the function button.Д¦.

III) To delete the contents of the formula box, click on the small blue 'X' button.

II) To check the contents for validity, click on the green check mark. Review: Formula Guides in the Variables Section VII) Proceed to step 6 below to create the formatting.ДЇormulas work exactly the same way as formulas for variables or the function bar. VI) To delete excess filters, click the 'X' button. V) For more than one filter, click on the '+' button. To pick from a list of values or select a different object or variable, click on the second '.' button that follows the value box. Shown here: Setting the condition on the CS Enrollment count field. (Explanations of the filters are in the Query Filter Operators Guide). II) The list of available objects and variables will appear: make your selection and click 'OK'. I) First, pick the object that you'd like to filter on in your condition by clicking the first '.' button and selecting 'Select an object or variable'.

Review: Query Panel Guide, Filter Operators Guide, Table Filters Guide These can be picked via the drop-down menu in the bar above the formula or condition.Д¬onditions work exactly the same way as filters. Rules can be added as conditions or as formulas. Add a description now or later as needed.ДҐ. In the Formatting Rule Editor, give your Formatting Rule a unique name. Navigate to the Analysis menu, then the 'Conditional' submenuД¤. This can be useful when you want to highlight some values usually, but the underlying data changes every time you run your report. Conditional Formatting, previously known as 'Alerters', refers to rules that you can set in place to change the formatting for only some values in your report.ДЇor example, conditional formatting can be used to change the font color to 'red' on only some, but not all, values in a column.