Forum Discussion

ShivaPrasad's avatar
ShivaPrasad
New Contributor
3 months ago

How to apply conditional formatting in Cell(Cell is having text)

Hi Team, Can any one help on this. I have text in the cells, so based on my text have to apply the conditional formatting. if my cell has "YES" text then should be Green color, if my cell has "...
Cube View
ShivaPrasad's avatar
ShivaPrasad
New Contributor
3 months ago

Hi Pranav,

I have tried this approach earlier, Created a Delimited parameter and Cell type as Combo box. given the parameter at Combo Box. and applied the formatting. but this scenario is not working. what i observed is when we are changing the cell type to Combo box. then it is not a cell to populate the amount. that's why below condition is not working.

If (CellAmount = 1) Then
BackgroundColor = Pink, TextColor = Red
'Else
' BackgroundColor = White, TextColor = Black
End If

  • pranav46's avatar
    pranav46
    Contributor II
    3 months ago

    What view member are you using.
    Use periodic or YTD and use one of the dummy UD to store 1 or 0. Only annoying would be it will display No data in combo box and other value.