To apply colors in Excel template We have created Formatting rules, but template allows maximum 3 formatting rules. Is there any way to add more formatting rules.
Hi @Haribabu Ch Trinamix
Can you confirm are you using Excel 2003 version as Excel Template? you can use the 2007+ version to apply more conditions.
Refer - https://docs.oracle.com/middleware/bi12214/bip/BIPRD/GUID-F926959D-B7A5-41DE-8388-2951666A38EE.htm#BIPRD2747
Regards,
Arjun
Hi Haribabu,
This is Microsoft Excel limitation, In Excel 97-2003, you will see the first three conditions only.
We have perquisite for designing excel template in documentation
Workaround- Please see the advanced features from the following doc for Border and Underline Styles -
https://docs.oracle.com/en/middleware/bi/analytics-server/design-publish/use-advanced-publisher-functions.html#GUID-0632CF5B-753A-4583-966B-1C75C7B45A17 https://support.microsoft.com/en-us/office/conditional-formatting-compatibility-issues-ef68c97a-1b5e-47eb-9b3f-a548f941df4f?ui=en-us&rs=en-us&ad=us
