Conditional formatting based on the value of other rows and columns

[AndreaF]

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

[JackLacava · Accepted solution]

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.

[tsequeira]

Hi!

In the Cell format, on rows formatting settings, you can define for example:

If (CellAmount <> 0) Then
BackgroundColor = red
End If

[AndreaF]

The code you posted checks the value of the cell itself. What I am looking for is formatting based on the value from a different cell (different row to be precise)