Excel Conditional formatting for String

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

답변 (0개)

카테고리

도움말 센터File Exchange에서 Data Import from MATLAB에 대해 자세히 알아보기

제품

릴리스

R2017b

질문:

2020년 10월 28일

Community Treasure Hunt

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

Start Hunting!

Translated by