Excel Conditional formatting for String

2020 10 28
0 个回答
2 次查看（30 天）

0 个投票

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

标签

提问:

sukanya
sukanya
2020-10-28

Community Treasure Hunt

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

Start Hunting!

Translated by