Excel Conditional formatting for String
15 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
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 Kommentare
Antworten (0)
Siehe auch
Kategorien
Mehr zu Data Import from MATLAB finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!