I am working on excel file. In that, I want to do conditional formatting for specfic text using ActiveX command. i.e. if any cell contains 'Input_' need to change cell colour and if any cell contais 'Output_' need to change cell colour and so on.
If apply for number it is working fine.But it is not working for specfic text. Please find blow code. which I commented for number.
condition_format = ['Type:=xlTextString, String:="Input_", TextOperator:=xlBeginsWith'];
Excel.Selection.FormatConditions.Add(2, , condition_format)
Can anyone help me out, how to do for specfic text?
Thanks in advance.