Excel Conditional formatting for String

조회 수: 14 (최근 30일)

sukanya 2020년 10월 28일

Hello,

I am trying to set excel conditional formatting cell fill, based on cell value which is a string. Can someone help me with the right code?

xlCellValue = 1;

xlEqual = 3;

Excel.Range(['G2:G' num2str(lastrow)]).Select;

Excel.Selection.FormatConditions.Add(xlCellValue, xlEqual, '=ABC');

Excel.Selection.FormatConditions.Item(3).Interior.ColorIndex = 46;

Thanks

Help Center 및 File Exchange에서 Data Import from MATLAB에 대해 자세히 알아보기

R2017b

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

Translated by