In this article, we will learn how to change color numbers based on the value result in Microsoft Excel 2010.
In Microsoft Excel, we can use Conditional Formatting to color numbers based on the value or condition. Conditional formatting is an important feature & is commonly used by the Excel users.
Conditional formatting quickly highlights the important information. There are many built-in formatting rules we can discover & use in the day to day work. We can use a custom formula to derive the output we want.
Let us understand with an example:
- We have Students data
- The total is calculated in row 6
- We want to show the total in Green color if it is greater than or equal to 250
- If total is less than 250, then it will be shows in Red color.
- Select the row in which we want to apply conditional formatting.
- Click on Home ribbon
- In Style group, click on Conditional Formatting
- Click on New Rule
- The “New Formatting Rule” dialog box will appear
- Select “Format only cells that contain” cell value greater than or equal to 25
- Click on Format & select green color or you can select the color of your choice.
- Repeating the same steps for total less than 250
- This is how the result looks
- To check how the conditional formatting works
- In Conditional formatting menu, click on Manage Rules
- The “Conditional Formatting Rules Manager” box will appear & show in details
- We can make any changes if required by clicking on Edit Rule.