Change colour of cells of an excel worksheet imported into matlab

Hi Guys,

I have an excel spreadsheet that contains a table of results of correlations between variables. I would like to read this document into matlab, then use a code that will loop through the worksheet and highlight every cell that is <0.05 in the colour green (to show a significant correlation), what code would I use to do this please?

Thanks

[Sindar]

Why do you want to use Matlab for this?

(In Excel, you can use conditional formatting to do the same thing in one step)

[Walter Roberson]

https://www.mathworks.com/matlabcentral/answers/509463-coloring-variable-cells-in-excel is pretty much the same.

Answer 1

[Monisha Nalluru]

I have attached the excel file for the reference work.

The code below is used to color a cell in third column with values greater than 5.

m=xlsread("testing.xlsx");
% Connect to Excel
Excel = actxserver('Excel.application');
% Get Workbook object
WB = Excel.Workbooks.Open(fullfile(pwd, 'testing.xlsx'),0,false);
for i=1:numel(m(:,3))
    if m(i,3)>5
        cell="C"+num2str(i);
        % Set the color of required cell of Sheet 1 to GREEN
        %color Index for GREEN is 4 in excel
        WB.Worksheets.Item(1).Range(cell).Interior.ColorIndex = 4;
    end
end
% Save Workbook
WB.Save();
% Close Workbook
WB.Close();
% Quit Excel
Excel.Quit();

Refer the following link:

https://www.mathworks.com/matlabcentral/answers/3352-how-to-set-excel-cell-color-to-red-from-matlab