Ability to have conditional format in the specific cell in pivot or table

User_J6AOQ

Description

In excel, we can set certain cells to be highlighted in yellow or red or any color depending on the condition even though we have multiple columns. For example, anything is more than 5, the cell highlights in red in column A. Anything is more than 5, it is in yellow in column B. However, in OA, it seems not to have that option. If we set the conditional format, it is highlighted the whole rows with multiple columns.

Use Case and Business Need

To have a big table or pivot with multiple columns, it is useful to have the conditional format to quickly highlight item. Sample of conditional format is attached.

Original Idea Number: f9da50559d

Jacques V.-Oracle

This feature is actively being worked on and is coming soon.   

You will be able to create "RULES" that will control color/font/styles or any visualizations.

rules can be simple like " Make yellow if actual > 5 " ,   they can also refer to other Measures like " Make Red if Actual > Budget "    or even " Make actual red if acutal is < than last year's actual " 

Hope that helps

Cheers

Jacques

 

User_J6AOQ

Great! Thanks a lot! Looking forward to see it!

Gabby Rubin-Oracle

In 6.1