1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Solved: excel 2010

Discussion in 'Business Applications' started by brobilly, Jan 31, 2011.

Thread Status:
Not open for further replies.
  1. brobilly

    brobilly Thread Starter

    Joined:
    May 22, 2007
    Messages:
    70
    I am working in a spread sheet with the following simple formula =SUM(B2,C2) and the result is in D3
    in some instances the result is a negative number and the result is shown as (10) but the number/text colour is black what I want to do is have a formula which changes the colour of the result to red if the result is negative and to remain black if the result is positive, is this possible and if yes how do I do it

    Many thanks
    Brobilly
     
  2. michelle_s

    michelle_s

    Joined:
    Jan 28, 2011
    Messages:
    15
    Hi Brobilly,

    Yes it's possible. Have a look at Conditional Formatting. Set the format to red if the value is less than 0 and set the format to black text if the value is greater than 0 (or greater than or equal to 0 if you class 0 as positive).

    if you want to have brackets around the number write the formula as ="(" & sum(B2,C2) & ")".
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/977989

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice