How to change Text color in the cell that contains negative numbers in Excel 2007

Microsoft Excel Tips

For example, I have the data such as in the Table below:



How to change the value negative numbers in the Amount Column with red color?

Follow the instructions below:
1. Select the data in the Amount column
Click Conditional Formating->Highlight Cell Rules-> Less then..




2. Enter the number “0” in Format cells that are LESS THAN: and select Red Text in the Box



3. Click OK

Now every negative number on the field will be colored red…Easy, right?

Related Topics:
How to Hide and Protect Pattern / Formula in Microsoft Excel 2007
How to Paste your data from Notepad to the Excel Columns
How to change Text color in the cell that contains negative numbers in Excel 2007
Microsoft Excel 2007: How to take limit value to the cell