In step 2 of your GridBuddy Connect Wizard for this grid, add Conditional formatting for color-coded visual alerts.
Click New Rule to create a conditional formatting rule.
Click Add to add multiple field conditions or formatting rules.
When creating a rule on a Date or Date Time field, you can use these relative dates for the value. The following relative dates are accepted by all datasources:
- THIS_QUARTER
- NEXT_QUARTER
- LAST_QUARTER
- THIS_YEAR
- LAST_YEAR
- TODAY
- TOMORROW
- YESTERDAY
- THIS_WEEK
- THIS_MONTH
- LAST_MONTH
- NEXT_MONTH
- LAST_90_DAYS
- NEXT_90_DAYS
- LAST_N_DAYS:n
- NEXT_N_DAYS:n
- LAST_WEEK
- NEXT_WEEK
- LAST_N_WEEKS:n
- NEXT_N_WEEKS:n
- LAST_N_MONTHS:n
- NEXT_N_MONTHS:n
- NEXT_YEAR
- LAST_N_YEARS:n
- NEXT_N_YEARS:n
- LAST_N_QUARTERS:n
- NEXT_N_QUARTERS:n
- N_DAYS_AGO
- N_WEEKS_AGO
- N_MONTHS_AGO
- N_QUARTERS_AGO
- N_YEARS_AGO
- N_FISCAL_QUARTERS_AGO
- N_FISCAL_YEARS_AGO
- THIS_FISCAL_QUARTER
- LAST_FISCAL_QUARTER
- NEXT_FISCAL_QUARTER
- NEXT_N_FISCAL_QUARTERS:n
- LAST_N_FISCAL_QUARTERS:n
- THIS_FISCAL_YEAR
- LAST_FISCAL_YEAR
- NEXT_FISCAL_YEAR
- NEXT_N_FISCAL_YEARS:n
- LAST_N_FISCAL_YEARS:n
The following Relative Dates only apply to Salesforce:
- LAST_90_DAYS
- NEXT_90_DAYS
- LAST_N_DAYS:n
- NEXT_N_DAYS:n
- LAST_WEEK
- NEXT_WEEK
- LAST_N_WEEKS:n
- NEXT_N_WEEKS:n
- LAST_N_MONTHS:n
- NEXT_N_MONTHS:n
- NEXT_YEAR
- LAST_N_YEARS:n
- NEXT_N_YEARS:n
- LAST_N_QUARTERS:n
- NEXT_N_QUARTERS:n
- N_DAYS_AGO
- N_WEEKS_AGO
- N_MONTHS_AGO
- N_QUARTERS_AGO
- N_YEARS_AGO
