Forum Discussion

KB's avatar
KB
New Contributor
3 years ago

Conditional formatting with up and down arrows

Hi all, I am trying to apply a conditional formatting to a variances column, if higher than last year then shown up arrow (color red) if lower than last year then down (color green). Not sure how...
Cube View
db_pdx's avatar
db_pdx
Valued Contributor

Hi KB: I don't know of a way to do arrows in a standard cube view.  The formatting options that would be most applicable for coloring in a Cube View would likely be:

  • TextColor
  • BackgroundColor
  • BorderColor
  • (+their Excel/Report equivalents)

You would set this in the Cube View > Rows and Columns > (select a report block) > Formatting > Cell Format.  Use a condition of If (CellAmount ... ) Then ...

Cheers    -DB

KB's avatar
KB
New Contributor
3 years ago

I have done that with cell format as Wingdings but not sure what I need to include to return a text?