how to assign a color to specific values in matrix
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
baran
am 15 Sep. 2014
Kommentiert: Image Analyst
am 15 Sep. 2014
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 Kommentare
Akzeptierte Antwort
Image Analyst
am 15 Sep. 2014
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 Kommentare
Image Analyst
am 15 Sep. 2014
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.
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu ActiveX 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!