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.

Excel Programming... or formatting

Discussion in 'Business Applications' started by AirPolgas, Jul 11, 2000.

Thread Status:
Not open for further replies.
Advertisement
  1. AirPolgas

    AirPolgas Thread Starter

    Joined:
    May 16, 2000
    Messages:
    207
    Anybody know how to format a cell like this?

    I would like my cell to total up a bunch of items, much like the Epsilon (at sum), but then I want the display font to be blue when it is positive, and then red when it is negative.

    Thank you.

    ------------------
    "There are no stupid questions, just stupid people." -- Mr. Garrison on South Park
     
  2. EAFiedler

    EAFiedler Moderator

    Joined:
    Apr 25, 2000
    Messages:
    14,136
    Highlight the cell, rows or columns you want formatted. On the Menu-Format>Conditional Formatting. Using the
    Cell is: Greater than: 0 and
    Cell is: Less than: 0
    and specifing the patterns or font you want for each particular scenario should get you what you want.

    The above uses two Conditional Formats you may be able to get your conditions set up using only one box. It also leaves 0 without a format so you may want it to be inclusive on the negative or positive result.

     
  3. AirPolgas

    AirPolgas Thread Starter

    Joined:
    May 16, 2000
    Messages:
    207
    Thank you very much.

    ------------------
    "There are no stupid questions, just stupid people." -- Mr. Garrison on South Park
     
  4. jmatt

    jmatt

    Joined:
    Apr 7, 2000
    Messages:
    755
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/36922

  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