Set conditional formating to Excel

版本 1.1.0.0 (1.4 KB) 作者: Tal Shir

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

关注

5.0

(2)

1.5K 次下载

更新时间 2009/2/26

查看许可证

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.

引用格式

Tal Shir (2024). Set conditional formating to Excel (https://www.mathworks.com/matlabcentral/fileexchange/23107-set-conditional-formating-to-excel), MATLAB Central File Exchange. 检索来源 2024/7/26.