Set conditional formating to Excel

Version 1.1.0.0 (1.45 KB) by Tal Shir
Set a conditional format in Excel to change negative numbers text color to red.
1.5K Downloads
Updated 26 Feb 2009

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.

Cite As

Tal Shir (2026). Set conditional formating to Excel (https://uk.mathworks.com/matlabcentral/fileexchange/23107-set-conditional-formating-to-excel), MATLAB Central File Exchange. Retrieved .

MATLAB Release Compatibility
Created with R2008a
Compatible with any release
Platform Compatibility
Windows macOS Linux
Version Published Release Notes
1.1.0.0

No Products Required

1.0.0.0