Conga Grid uses JavaScript to create Conditional Formatting rules. For basics on creating Conditional Formatting rules, see Conditional Formatting.

Here are some examples of some more advanced Javascript Rules. Copy and paste the JavaScript Examples in the matrix below into the Conditional Formatting Advanced JavaScript Box.

: The Conga Support Team does not support JavaScript solutions and the creation of advanced formulas. Only best efforts are expected from the Conga Support team using the basic selection criteria.

: 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 DescriptionOpportunity Rule Values
Big Money: Color the Amount field Green and bold/italicize that field if the field value is above $30,000.
  • Rule Name - Big Money
  • Field - Amount
  • Cell Color - Unchanged
  • Text Color - Green
  • Text Style - Bold and Italics enabled
  • Apply to Row - False
  • JavaScript:
Amount >= 30000
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.
  • Rule Name - Low Or No Activity
  • Field - Last Activity
  • Cell Color - Grey
  • Text Color - Black
  • Font Style - Bald
  • Apply to Row - False
  • JavaScript:
(((((new Date() - LastActivityDate) / (1000*60*60*24)) -1) > 7) || (LastActivityDate == null)) && !StageName.contains('Closed')
Case Rule Name and DescriptionCase 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).
  • Rule Name - Older than 1 Hour
  • Field - Contact
  • Cell Color - Red
  • Text Color - Black
  • Font Style - Bold
  • Apply to Row - True
  • JavaScript
((((new Date() - CreatedDate) / (1000*60*60)) -1) > 0)