Windows Forum

Ask something
Discussion Locked

Excel Text Colours

0 helpful
7 replies

by danfalconar

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I would like to know how to change the colour of text in Excel, but change it in a formula. For example, I wish to use a formula that will change a number to RED when the number falls below a certain threshold. It would be something like this:
=IF(CELL<1000,BLACK TEXT,RED TEXT), only the words would be changed for the references I need.

The background is as follows: I do all of my accounts using Excel, and I have a weekly income. I want the weekly income figure to automatically turn red if it is below a certain threshold. I can also incorporate this idea into many other aspects of my accounts.

If anyone could help I would be grateful.

7 replies

by jim_rau

If you start Excel (I have Excel97) and choose Help>>Contents and Index>>Index and type in Conditional Formats you will get a lot of info on how to implement. I use this and it works very well and is easy to implement.

Enjoy!

by al hedstrom

Yes, Conditional Format is the tool you're looking for. Under the Format menu, select conditional format. Though you don't specifically use the formula syntax that you've cited, the result is the same. You set the first criteria or condition (less than), and assign a format for it (that's why its called "Conditional Format!"). Then you hit the Add button and assign a greater than/equal to criteria and then set the format for that.

The technical term for this is "cool." Try it; you'll like it.

Al Hedstrom

This discussion is closed to new replies.