General discussion

Locked

Excel Text Colours

By danfalconar ·
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.

This conversation is currently closed to new comments.

7 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Excel Text Colours

by jim_rau In reply to Excel Text Colours

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!

Collapse -

Excel Text Colours

by danfalconar In reply to Excel Text Colours

The question was auto-closed by TechRepublic

Collapse -

Excel Text Colours

by Al Hedstrom In reply to Excel Text Colours

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

Collapse -

Excel Text Colours

by danfalconar In reply to Excel Text Colours

The question was auto-closed by TechRepublic

Collapse -

Excel Text Colours

by SmokeyBear In reply to Excel Text Colours

If currentcell.Value < 1000 Then
celval.Select
Selection.Font.ColorIndex = 5
End If

Collapse -

Excel Text Colours

by danfalconar In reply to Excel Text Colours

The question was auto-closed by TechRepublic

Collapse -

Excel Text Colours

by danfalconar In reply to Excel Text Colours

This question was auto closed due to inactivity

Back to Windows Forum
7 total posts (Page 1 of 1)  

Related Discussions

Related Forums