Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 49 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 287 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.3K Oracle Analytics and AI Forums
- 6.5K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 110 Oracle Analytics and AI Trainings
- 21 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Conditional formatting in XML rtf Template (want to format the cell to red color when total is < 0)
Summary
Conditional formatting in XML rtf Template (want to format the cell to red color when total is < 0)
Content
Hi,
I want to conditionally format the cell to red color when when the total is < 0. I used the below tag, it is giving me error "Caused by: oracle.xdo.parser.v2.XSLException: <Line 136, Column 100>: XML-22047: (Error) Invalid instantiation of 'Attribute' in 'Element' context.".
Tag used:
<?if:CF_DELTA_BG_TOT<0?>
<xsl:attribute xdofo:ctx="block" name="background-color">red</xsl:attribute><?end if?>
Appreciate help.
Screenshot below. (output type : excel)

Thanks
Sreedhar
Answers
-
Check Conditionally Highlighting a Row in below
<?if@row:number(SAL)>2000?><?attribute@incontext:color;'red'?><?end if?>
0 -
this worked for me.
The correct condition is:
<?if:CF_DELTA_BG_TOT<0?>
<span style="font-size: 10.0pt; color: #333333;"><xsl:attribute name="background-color" xdofo:ctx="incontext">red</xsl:attribute></span><?end if?>
0 -
Hi, Please find the below error after using the above tag.
0