Bookmark page
Printable version
Course updatesForum home » Delegate support and help forum » Microsoft Excel Training and help » Change colour of text
|
|
|
Bookmark this page|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Change colour of text
Resolved · Low Priority · Version 2003
Reply
Change colour of text
Hi, I'd like to use a function (IF Function I think?) to change the colour of text. I want values of less than 0 to be blue, greater than 0 to be red, and 0 to be black.Can you tell me how to do this please?
Thanks
For upcoming training course dates see: Pricing & availability
RE: Change colour of text
Hi DeirdreThank you for your question
I suggest using the conditional formating tool.
1.Select the range of cells to format
2.Go to format and conditional formating
3.For condition 1 select less than and type 0 into the value box
4. Click on Format button and set the font format to be blue
5. Click Add to add another condition
6. Choose equal to and type in 0. Set format to black
7. Add another condition
8. Here the condition is greater than 0 and the format is red
Regards
Stephen
|
 |
|
» Forum post: Shortcuts |
Where do I find the list of short cuts? e.g. CTRL Z is undo
