Conditional Formatting
Conditional formatting lets you highlight your workbook visualization results based on rules you set. Right now, you can only apply conditional formatting to table views and pivot tables if the fields have NUMBER or STRING values. This includes standard, custom, formula, and calculated measure fields. Fields with DATE values aren't supported.
Conditional formatting does not differentiate between values in multiple currencies. For example, if you set a rule to highlight results over 10 dollars, any value over 10 euros will be highlighted too. To highlight results accurately when using multiple currencies, convert or consolidate the values before applying conditional formatting. For more information, see Currency in Datasets and Workbooks.
To use conditional formatting on percentage fields, you have to use decimal values in the rule. For example, if you want to highlight results greater than 20%, use 0.2 in your rule.
Conditional formatting doesn't currently let you filter results by color or icon. If you apply conditional formatting to a numeric field, you can sort the highlighted results in ascending or descending order to mimic filtering.
Any conditional formatting you use on a table view or pivot table is automatically applied to Analytics portlets based on that visualization. To turn off conditional formatting in the portlet, edit the visualization in its workbook. For more information, see Opening Workbooks from the Analytics Portlet.