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 MG,

Thank you for the response, if possible, Can you please provide an example CV Extender rule to make a formatting.  It will help us to get the result

  • pranav46's avatar
    pranav46
    Contributor II
    3 months ago

    I used combo box which has literal parameters.

    1 = YES

    2= NO 

    then use below formatting 

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

    Hope this help but get in idea stream