how to assign a color to specific values in matrix

Question

baran 2014-9-15

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/154913-how-to-assign-a-color-to-specific-values-in-matrix

评论： Image Analyst 2014-9-15

hi , i have excel file, i am trying to write a code that find same values in my excel file and assign color to each same values, for example for all "1" assign red. and then make a plot for me,

please help me thank alot

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Image Analyst 2014-9-15

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/154913-how-to-assign-a-color-to-specific-values-in-matrix#answer_151778

ExcelDemo.m

You'll need to use ActiveX. How familiar are you with ActiveX? You can record a macro to do the same thing in Excel then look at the VBA code in Excel and try to copy it over to your MATLAB code. See my ActiveX demo, attached.

2 个评论
显示无隐藏无

baran 2014-9-15

thanks but is there any other way? i dont understand how can i use your exceldemo for my problem. what i should change in this file? is there any easier way? thanks so much

Image Analyst 2014-9-15

No. MATLAB has no way to directly change the color of cells in Excel other than ActiveX, none that are practical or easier anyway. Perhaps you want to make an Excel macro that your user can run to colorize the cells that need coloring.

请先登录，再进行评论。