Color numbers based on the Value Result in Microsoft Excel 2010





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

 
img1
 

  • 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

 
img2
 

  • 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.

 
img3
 

  • Repeating the same steps for total less than 250

 
img4
 

  • This is how the result looks

 
img5
 

  • 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

 
img6
 

  • We can make any changes if required by clicking on Edit Rule.

 



9 thoughts on “Color numbers based on the Value Result in Microsoft Excel 2010

  1. “Hi,

    A friend of mine is working on a spreadsheet. She is inputting contact information and in one particular column she is adding phone numbers. In that column, she added an email address and it automatically turned into a link (it was underlined and the type turned red). Now when she attempts to type a phone number in that same column, different cell, it turns red and is underlined. What is happening here and how can she eliminate whatever formatting is occurring????
    Thanks!”

  2. “Hi Gayle,

    Select the cell, click on Format – Cells.

    Change it to General or whatever format you prefer.

    Alternatively, use the format painter icon to copy the format of another phone number that is already how you want it to look.

    HTH,

    Alan.”

  3. “Hey Alan,

    Thanks, but we already tried that and it didnt work. Eversince she put the email address into the column, everything now in that column turns red and is highlighted as if it were a link.

    Gayle”

  4. Gayle, clieck on the cell that has the hyperlink (red and underlined) , it will go to the web site . GO back to that cell. Then on the menu bar , go to Insert, Hyperlink. In the window that opens up , go to the bottom left where there is an option “Remove Link”, select that. Your cell will not have that hyperlink anymore.

  5. Gayle, click on the cell that has the hyperlink (red and underlined) , it will go to the web site . GO back to that cell. Then on the menu bar , go to Insert, Hyperlink. In the window that opens up , go to the bottom left where there is an option “Remove Link”, select that. Your cell will not have that hyperlink anymore.

  6. A friend of mine is working on a spreadsheet. She is inputting contact information and in one particular column she is adding phone numbers. In that column, she added an email address and it automatically turned into a link (it was underlined and the type turned red). Now when she attempts to type a phone number in that same column, different cell, it turns red and is underlined. What is happening here and how can she eliminate whatever formatting is occurring???? 

  7. “Select the cell, click on Format – Cells.

    Change it to General or whatever format you prefer.

    Alternatively, use the format painter icon to copy the format of another phone number that is already how you want it to look. “

  8. Thanks, but we already tried that and it didnt work. Eversince she put the email address into the column, everything now in that column turns red and is highlighted as if it were a link.

  9. Gayle, clieck on the cell that has the hyperlink (red and underlined) , it will go to the web site . GO back to that cell. Then on the menu bar , go to Insert, Hyperlink. In the window that opens up , go to the bottom left where there is an option “Remove Link”, select that. Your cell will not have that hyperlink anymore.

Leave a Reply

Your email address will not be published. Required fields are marked *


8 − six =

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>