Skip to main content
E
eeisenberg
Newcomer
July 22, 2024
Solved

CubeView Conditional Formatting based on cell value

  • July 22, 2024
  • 2 replies
  • 32 views

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.

2 replies

T_Kress
T_KressAnswer
Contributor
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.

    Clint_Holt
    Clint_Holt
    Member
    July 1, 2026

    I figured it out!  I was using an XFBR string to populate the row filters of my Cube View.  Before I returned that string I used it to pull a databuffer and analyze the values being returned.  if anything fell outside my threshold I added the “:Name()” to the row filters in order to prepend some special characters to the row header.  Then I went to the cube view and used the normal conditional formatting to look for row headers that contained my special characters and update the background color.  Admittedly an enhancement would be nice, but this gets me what I need for the time being.  I hope this helps!

    Terms & ConditionsAccessibility statement