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.
5.0
(2)
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 (2024). Set conditional formating to Excel (https://www.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

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Version Published Release Notes
1.1.0.0

No Products Required

1.0.0.0