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
