Skip to main content
May 22, 2024
Solved

Conditional formatting based on the value of different rows/columns

  • May 22, 2024
  • 1 reply
  • 0 views

Hi all, I have the same question as AndeaF (https://community.onestreamsoftware.com/t5/Reporting/Conditional-formatting-based-on-the-value-of-other-rows-and/td-p/20227
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.

Jacky_C_0-1716372632873.png

Thank you.

 

Best answer by T_Kress

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)

 

 

 

 

 

1 reply

T_KressAnswer
May 24, 2024

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)