How to fill color any cell in excel

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!

[KL]

and why do you want to do it with matlab?

Answer 1

[Image Analyst]

Use ActiveX, like in the attached demo.

The line you want to have is:

Excel.Worksheets.Item(1).Range(cellReference).Interior.ColorIndex = cellFillColorIndex;

[Manh Cuong Bui]

Thank you very much! can you give me an example that use this statement: Excel.Worksheets.Item(1).Range(cellReference).Interior.ColorIndex = cellFillColorIndex;