Skip to main content
Expert
May 26, 2023 1:40 PM UTC
Solved

Conditional formatting based on the value of other rows and columns

Hi all, does this 2021 OS community post by OneStream still hold true?

AndreaF_3-1685107308710.png

 

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)?

AndreaF_2-1685107274460.png

Thank you

Employee - Sage
May 26, 2023 4:15 PM UTC

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.

4 replies

Employee - Sage
May 26, 2023 4:15 PM UTC

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.

Member
May 30, 2023 10:00 AM UTC

Hi!

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

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

 

 

 

 

AndreaFAuthor
Expert
May 31, 2023 8:52 AM UTC

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)