Set conditional formating to Excel
by Tal Shir
25 Feb 2009
(Updated 26 Feb 2009)
Set a conditional format in Excel to change negative numbers text color to red.
|
Watch this File
|
| File Information |
| Description |
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.
|
| MATLAB release |
MATLAB 7.6 (R2008a)
|
|
Tags for This File
|
| Everyone's Tags |
|
| Tags I've Applied |
|
| Add New Tags |
Please login to tag files.
|
| Comments and Ratings (1) |
| 04 Jun 2009 |
Aviator
|
|
|
| Updates |
| 26 Feb 2009 |
No Products Required |
|
Contact us at files@mathworks.com