CRM On Demand - Reports and Dashboards (MOSC)

MOSC Banner

Conditional Formatting

edited Nov 7, 2013 5:29AM in CRM On Demand - Reports and Dashboards (MOSC) 6 commentsAnswered
 Hello Every one,

I have a question. For one of my clients the requirement is to change the color on the column based on Pick list values in the report. For that currently we are using Conditional Formatting. i.e

1. If the Picklist value is 'Recieved' then the data in one of the column should be Yellow. 
2. If the value is 'Recomended' then the color should be 'Green'.
3. If the 'Date Delivered'(a Custom date field) exceeds 5 business days then the associated cell with value ‘ Recomended’        automatically needs to turn Red.

Point #1 and #2 are working perfect but I am stuck with #3. Any idea how to make it automatically turn red based on Business days.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center