Excel Conditional formatting for String

16 vues (au cours des 30 derniers jours)

sukanya le 28 Oct 2020

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

En savoir plus sur Data Import from MATLAB dans Help Center et File Exchange

R2017b

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

Translated by