: Conditional Formatting Order: One thing to keep in mind when creating Conditional Formatting rules is the order of the views, which is modified by clicking and dragging up and down. Rules at the top of the list will override rules below it, so if there are two rules that have conflicting data, that rule that is above the other is addressed.
|Opportunity Rule Name and Description||Opportunity Rule Values|
|Big Money: Color the Amount field Green and bold/italicize that field if the field value is above $30,000.|
|Low or No Activity: Highlight any open Opportunities that have not been modified for over a week.: This uses an OR function, where OR is represented as "||". We are checking in the first half if the current date is older than the LastAcitivityDate field by 7 days, OR if the LastActivityDate field is blank and is not Closed.|
|Case Rule Name and Description||Case Rule Values|
|Older than 1 Hour: If a case with a 1 hour SLA is open for more than an hour, highlight the entire record Red.|
: This is using the same time variation as before, but it checks against hours instead of days. Remove the 24 hour segment of the Time and focus on Hours (the second 60).