-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
I need to know how to put in red %'s
- Thread starter ROCHI
- Start date
Greg Truby
MrExcel MVP
- Joined
- Jun 19, 2002
- Messages
- 10,025
Rochi,
I am having difficulty understanding exactly what you want to do. If English is not your first language, feel free to try posting in your native tongue.
Kind regards,
I am having difficulty understanding exactly what you want to do. If English is not your first language, feel free to try posting in your native tongue.
Kind regards,
Upvote
0
Click on the cell in question, then click on Format, Conditional Formatting...
Under Condition 1, make sure it says, "Cell Value Is", and in the next slot, select "less than" from the pull-down menu; in the last slot, enter 0.1 Now, click on Format, select the red color from the Color: pull-down menu, and, if you wish, Bold. Then, click on OK, and again on OK. That does it!
Under Condition 1, make sure it says, "Cell Value Is", and in the next slot, select "less than" from the pull-down menu; in the last slot, enter 0.1 Now, click on Format, select the red color from the Color: pull-down menu, and, if you wish, Bold. Then, click on OK, and again on OK. That does it!
Upvote
0
