Excel Programming... or formatting

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

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
 

EAFiedler

Retired Moderator
Joined
Apr 25, 2000
Messages
14,172
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.

 

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
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

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 807,865 other people just like you!

Latest posts

Top