Categories
Adding conditional formating to BI Publisher Pivot table on Excel
Hello Team,
I am trying to add conditional formatting to a pivot table I have created on Excel BI Publisher :
For this table for example I have added two conditions on the data cell :
But when I published this template I can see that only the first condition is applied and so with excel conditional formatting we can only apply one condition on the same field,
Is there another way to apply multiple conditional formatting on BI Publisher Pivot table on Excel ?
Thanks,
Chaima.
Best Answer
-
I saw you have logged an SR for the same , we checked with Dev team on this and this is an product behavior/limitation. There is no workaround available .
—> Limitations of Excel Templates
When you use an Excel template, you can't use conditional formatting based on the generated data to change the background color of a cell in the report output.
We are working internally to add the same to product documentation. i hope we have answered your question. can you pls mark it as Answered.
Regards,
Arjun
0
Answers
-
0
-
Hello @Mallikarjuna Kuppauru-Oracle
Thank you for the quick response,
I reviewed this documentation but I believe it is for Microsoft Word, not Excel,
also, this is for a regular table and not a Pivot one, I have noticed that BIP conditional formatting does not apply to the pivot table.
Regards,
Chaima.
0 -
Yes previous link for RTF , can you refer below -
See the Note in Prerequisites section - Excel 2003 allows only three conditional formatting rules per cell, but Excel 2007 allows more.
I have not noticed any limitation for pivot table .
Regards,
Arjun
0 -
@Mallikarjuna Kuppauru-Oracle How to highlight a color for a numeric field in Excel Template. Thanks.
0