File Exchange

image thumbnail

Set conditional formating to Excel

version 1.1 (1.45 KB) by

Set a conditional format in Excel to change negative numbers text color to red.

4 Downloads

Updated

View License

Set a conditional format in Excel to change negative numbers' text color to red.
The code can be modifeid quite easly to set any other condition.
Example:
a=randn(100,1)
xlswrite('a',a)
xlsCondFormNeg('a','Sheet1','A1:A50')

This Example will set the conditional formating to the first 50 numbers in the column.

Comments and Ratings (1)

Aviator

Great capability. Can you tell me what needs to be changed in this code if I want to set a condition that: when/if any content of for instance 'C1:C10' is less (or) greater than 'B1:B10' turn that cell in the range 'C1:C10', Red???

Thanks,

Updates

1.1

No Products Required

MATLAB Release
MATLAB 7.6 (R2008a)

Download apps, toolboxes, and other File Exchange content using Add-On Explorer in MATLAB.

» Watch video