Problem with Conditional formatting and dynamic reference in row

[Former Member]

Hello!

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 ...

Thanks in advance Julian!

[former_member186338 · Accepted solution]

Hi Julian,

Conditional formatting works correctly!

$BA22 - 22 has to be the row of the cell on the formatting sheet, not on the report!

Vadim

[former_member186338 · Accepted solution]

For example, if we are talking about default column data format:

Then Row will be 32

Vadim

[Former Member · Accepted solution]

Hi Vadim,

at first, I don't understand, but then I saw your screeenshot!

Thank you very much!!!!