Formula to change Font Color in Microsoft Excel 2010

If we want to change the font color of some cells to show some noticeable difference between the cells, we can do this using conditional formatting.

  • We have few random numbers in cells A2:A11
  • The sum of these cells is calculated in cell B2.
  • We have defined three conditions in column E in the below picture.
  • If the value in cell B2 meets the condition then the font color will change automatically.

 

See the below picture

 

img1

 

Lets see how we can use conditional formatting to show a value with different font colors according to the defined conditions:

    • Select cell B2 where the font color needs to be changed. Click on the Home tab on the Ribbon, select Conditional Formatting & then New Rule

 

img2

 

    • On selecting New Rule, the New Formatting Rule dialog box will appear. Then select Format only cells that contain

 

img3

 

    • Select Cell Value greater than 100 which is our condition
    • Click on the Format button, then click on the Font tab and choose the color from the drop down. Letsselect Red.

 

img4

 

    • Follow the above steps again for other conditions for the Blue & Yellow colors. Ensure that you change the parameter from greater than to less than 100 for blue and equal to 100 for yellow.

 

img5

 

  • Click on Ok
  • We will get our output as the below picture.

 

img6

 

Users are saying about us...

  1. Pingback: Article Marketing Profit Pack

Leave a Reply

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

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>

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube