Skip to main content
E
eeisenberg
July 22, 2024
Solved

CubeView Conditional Formatting based on cell value

  • July 22, 2024
  • 1 reply
  • 1 view

Hi all,

I am trying to use conditional formatting in a cubeview and color all of the columns but I want it based on the cell value in Col3, not its own cell value.

I have If (CellAmount > 0) Then ReportBackgroundColor = Green --- but I want it to be Col3 cell amount coloring col5.

 

Is this possible?

Best answer by T_Kress

It is not possible to do conditional formatting based on another columns value dynamically.


You do have the ability to call an XFBR string rule in a cube view row to dynamically format a column. However, for each row you want to apply this logic for, you would need to pass in the exact intersection to check the "SourceColumn" for in the rule to retrieve the row's "SourceColumn" value and determine how to dynamically format the column for the given row. This would not be dynamic.

We do have a enhancement request for this here:  https://community.onestreamsoftware.com/t5/Platform/CV-Conditional-Formatting-Based-on-Another-Column-or-Cell-Value/idi-p/5489

You can go there and vote for it.

1 reply

T
T_KressAnswer
July 22, 2024

It is not possible to do conditional formatting based on another columns value dynamically.


You do have the ability to call an XFBR string rule in a cube view row to dynamically format a column. However, for each row you want to apply this logic for, you would need to pass in the exact intersection to check the "SourceColumn" for in the rule to retrieve the row's "SourceColumn" value and determine how to dynamically format the column for the given row. This would not be dynamic.

We do have a enhancement request for this here:  https://community.onestreamsoftware.com/t5/Platform/CV-Conditional-Formatting-Based-on-Another-Column-or-Cell-Value/idi-p/5489

You can go there and vote for it.

Terms & ConditionsAccessibility statement