Actually I've a tricky problem with conditional formatting in EPM Formatting Sheet.
I want to highlight a cell, if the value in column "BA" of the same row is higher. Therefore I added a conditional formatting to the cell in the formatting sheet with the cell reference "=$BA22", like it would work in a normal excel sheet. On my first refresh it worked, but on the next refresh(es) it doesn't work anymore. If I look to the conditional formatting in my report, the cell reference "=$BA22" changes to "=$BA1048460".
Does anyone have an idea, how to solve this? It should work like Risha Gupta wrote in Conditional Formatting From EPMFormattingSheet ...
Thanks in advance Julian!