Skip to main content
A
Anonymous
December 17, 2020

Can you reference two different columns when attempting to apply conditional formatting in a cube view?

  • December 17, 2020
  • 2 replies
  • 0 views
Originally posted by Jill Balke

I am looking to do a conditional formatting that would return a result based on a cube view showing both a variance dollar amount of over $4m and over 5% which are in two different columns of my cube view, and I haven't been able to figure out how to look at data in more than one column for conditional formatting yet.  Would this be possible?

    2 replies

    A
    Anonymous
    February 19, 2021
    Originally posted by Colin ONeill

    I don't know 'OneStream conditional formatting', but in Excel, the conditional formatting would look like this:

     

    Select cell(s) to apply the conditional formatting to.

    Home > Styles > Conditional Formatting

    Use a formula to determine which cells to format

       Format values where this formula is true:

          =AND($G5>4000000, $H5>0.05)

       Click Format

          Add shading format as desired

       Click OK

    Hope this helps.

    R
    Rutger
    Newcomer
    March 23, 2023

    Any luck on how to do this in OneStream? 

    Terms & ConditionsAccessibility statement