How to fill color any cell in excel

4 次查看（过去 30 天）
Manh Cuong Bui
Manh Cuong Bui 2017-12-16
评论： Manh Cuong Bui 2017-12-18
Hi I got a trouble. I have an excel table that contains even and odd values I want to find odd values and fill color it like the picture.
Thank you very much!

请先登录，再回答此问题。

采纳的回答

Image Analyst
Image Analyst 2017-12-16
Use ActiveX, like in the attached demo.
The line you want to have is:
Excel.Worksheets.Item(1).Range(cellReference).Interior.ColorIndex = cellFillColorIndex;
  1 个评论
Manh Cuong Bui
Manh Cuong Bui 2017-12-18
Thank you very much! can you give me an example that use this statement: Excel.Worksheets.Item(1).Range(cellReference).Interior.ColorIndex = cellFillColorIndex;

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 ActiveX 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by