12-17-2020
05:00 AM
- last edited on
08-11-2023
10:39 AM
by
JackLacava
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?
02-19-2021
11:39 AM
- last edited on
08-11-2023
10:40 AM
by
JackLacava
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.
03-23-2023 11:15 AM
Any luck on how to do this in OneStream?