View License

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

» Watch video

Highlights from
Set conditional formating to Excel

Join the 15-year community celebration.

Play games and win prizes!

» Learn more

5.0 | 1 rating Rate this file 7 Downloads (last 30 days) File Size: 1.45 KB File ID: #23107 Version: 1.1

Set conditional formating to Excel


Tal Shir (view profile)


25 Feb 2009 (Updated )

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

| Watch this File

File Information

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.

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   Please login to tag files.
Please login to add a comment or rating.
Comments and Ratings (1)
04 Jun 2009 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???


26 Feb 2009 1.1

No Products Required

Contact us