Conditional formatting based on the value of different rows/columns

[Jacky_C]

Hi all, I have the same question as AndeaF (https://community.onestreamsoftware.com/t5/Reporting/Conditional-formatting-based-on-the-value-of-ot...) 
Is the below solution post by OneStream still the only workaround for the question? I am trying to compare the variance of prior year and current year data and want to return a specific number format based on the two numbers.

Thank you.

[T_Kress · Accepted solution]

I believe this is still the preferred work around.  There are two ideas on IdeaStream though that pertain exactly to this so you should definitely up-vote these two ideas so they may get a higher priority:

JIRA Ticket: PF-17146 (onestreamsoftware.com)

JIRA Ticket: PF-6963 (onestreamsoftware.com)