Trouble in maintaining text color format on pivot table

[#1]

The issue seems to be rather weird as the color formatting goes off for some of the text. Kindly see highlighted text on the screenshot below.

I am not typing any of this word so there will be no room for any typos.The script is based on the first column and there are no issue's in the first column.

=if(YERptGroupName='TOTAL INCOME'or YERptGroupName='SUB-TOTAL' 
or YERptGroupName='TOTAL OPERATING EXPENSES' OR YERptGroupName='PROFIT BEFORE TAX (PBT)' 
OR YERptGroupName='PROFIT AFTER TAX (PAT)', RGB(0,0,128))

[sujeetsingh]

what do you want to implement through this code

[#3]

I am basically trying to highlight the sub-totals and totals with color  from other rows on my pivot table. The code above simply explains, if the first column contains a row with the string SUB-TOTAL, change the text color to blue.

This works fine for the first column but does not work for the second column as you can see the screenshot above.

[sujeetsingh]

Got it but a little clearence needed....so here you are writting that

if (yertptgroupname='sss',red(),yelluw())

what ever the needed is .....

but please explain the condition you want the colors to be...

[#5]

The conditions are simple. I just need some specific words to be in bold and colored.
I have 2 pivot tables, one that shows values from account groups and the other with the account details.

See screenshot below.
First Pivot:

Second Pivot (With details)

If you can notice on the second screenshot the colors are missing one one of it. If click on the account name then it shows with color.

[Anonymous]

Is the colour missing on the account row because there is a no data associated to that row ?

Can you add a new field to the datamodel table, alongside the 'P&L Group Name' field, to show whether bold or not, then just test for that in your background colour and text format expressions.

Jonathan