Conditional formatting based on the value of other rows and columns
Hi all, does this 2021 OS community post by OneStream still hold true?
I would like the cells from the FTE row to be formatted in a certain way (for example set the background to red) when the FTE check cell amount is not zero. Is there a way other than the XFBR they suggest (which looks like an overkill for what I need to do)?
Thank you
Not that I know (although CVs are not exactly my forte). As an alternative idea, you could put the check cells on columns instead, side-by-side with the actual value, basically creating a traffic-light report. You would then probably have to override it for other rows.
If this is on a Dashboard, you might want to look into Pivot Grids, which have some additional (and pretty cool) formatting options, including calculated fields.
