MATLAB Answers

change cell color in excel conditional formatting

18 ビュー (過去 30 日間)
Murugan C
Murugan C 2019 年 11 月 13 日
Hello all,
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'];
% condition_format =['=' range '<6']; %for number
Excel.Selection.FormatConditions.Add(2, [], condition_format)
Can anyone help me out, how to do for specfic text?
Thanks in advance.

  0 件のコメント


回答 (0 件)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by