Skip to Content
Former Member
Oct 08, 2014 at 12:21 PM

Problem with Conditional formatting and dynamic reference in row



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!