Question

Hiring managers at Universal Containers would like a visual mechanism for determining review score outliers. Review scores are captured as a custom field on a custom Review object and can range from 1 to 10. Any review score that is > 8 should be highlighted in Green. Any review score that is < 4 should be highlighted in Red. How would a developer accomplish this?

1) use Matrix Reports
2) use charts
3) use Conditional Highlighting
4) use custom summary formulas

Answer 1

A Salesforce developer can use Conditional Highlighting in a report to highlight review score outliers, with scores higher than 8 in green and those lower than 4 in red.

Step-by-step explanation:

To create a visual mechanism for determining review score outliers in Salesforce, a developer can utilize Conditional Highlighting. This feature is often available in Salesforce reports and allows users to apply color-coded formatting rules to report cells based on their values. In this scenario, the developer would create a report with the custom Review object, and then set up conditional highlighting rules to show scores higher than 8 in green and scores lower than 4 in red. Using this method will instantly inform hiring managers at Universal Containers about which review scores are considered outliers without having to analyze data manually.