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

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