A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Excel: want neg numbers to show red/pos green via if-then formula



 
 
Thread Tools Display Modes
  #1  
Old June 15th 06, 06:34 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: n/a
Default Excel: want neg numbers to show red/pos green via if-then formula

I am trying to have the negative numbers in a cell turn red and positive ones
turn green as the values change. I would like a formula that says "If number
is negative, display text red" and "If positive then display green."

I know you can make negative numbers red in options, but the spreadsheet is
linked to data that changes in real-time and would like it to automatically
change.
Ads
  #2  
Old June 15th 06, 06:41 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: n/a
Default Excel: want neg numbers to show red/pos green via if-then formula

Look at Format==>Conditional formatting.

Select column then Format=>Conditional formatting:

Condition 1 ==> Cell Value is: less than 0, set font to RED
Condition 2 ==> Cell Value is: Greater than 0, set font to GREEN

HTH

"Jim" wrote:

> I am trying to have the negative numbers in a cell turn red and positive ones
> turn green as the values change. I would like a formula that says "If number
> is negative, display text red" and "If positive then display green."
>
> I know you can make negative numbers red in options, but the spreadsheet is
> linked to data that changes in real-time and would like it to automatically
> change.

  #3  
Old June 15th 06, 07:10 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: n/a
Default Excel: want neg numbers to show red/pos green via if-then formula

Just set the normal text in those cells as GREEN, and format them to display
negative numbers as RED.....note, zero also is displayed as GREEN this way....

Vaya con Dios,
Chuck, CABGx3



"Jim" wrote:

> I am trying to have the negative numbers in a cell turn red and positive ones
> turn green as the values change. I would like a formula that says "If number
> is negative, display text red" and "If positive then display green."
>
> I know you can make negative numbers red in options, but the spreadsheet is
> linked to data that changes in real-time and would like it to automatically
> change.

  #4  
Old June 15th 06, 11:24 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: n/a
Default Excel: want neg numbers to show red/pos green via if-then form

try conditional formatting

"CLR" wrote:

> Just set the normal text in those cells as GREEN, and format them to display
> negative numbers as RED.....note, zero also is displayed as GREEN this way....
>
> Vaya con Dios,
> Chuck, CABGx3
>
>
>
> "Jim" wrote:
>
> > I am trying to have the negative numbers in a cell turn red and positive ones
> > turn green as the values change. I would like a formula that says "If number
> > is negative, display text red" and "If positive then display green."
> >
> > I know you can make negative numbers red in options, but the spreadsheet is
> > linked to data that changes in real-time and would like it to automatically
> > change.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 97 formula doesn't work in Excel 2003 [email protected] Excel Discussion (Misc queries) 2 April 4th 06 09:34 PM
Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? C-Man23 Excel Worksheet Functions 3 January 19th 06 09:52 AM
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER MEGTOM New Users to Excel 5 October 27th 05 03:06 AM
Formula checking multiple worksheets sonic-the-mouse Excel Worksheet Functions 2 June 5th 05 07:48 PM
How do I sort letters before numbers in Excel? RiverGirl Excel Discussion (Misc queries) 4 May 27th 05 04:09 PM


All times are GMT +1. The time now is 02:08 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Copyright 2004-2014 ExcelBanter.
The comments are property of their posters.