Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How To Detect A Negative Number In A Cell
Greetings,
I am trying to detect whether the value in cell M for each row has a negative number. If it does I need to change the text color for that row to red. Any help, insights or links would be greatly appreciated. -Minitman |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How To Detect A Negative Number In A Cell
Select column MCell formattingCategory:NumberSelect one of red patterns
for negative numbers Regards, Stefi €žMinitman€ť ezt Ă*rta: Greetings, I am trying to detect whether the value in cell M for each row has a negative number. If it does I need to change the text color for that row to red. Any help, insights or links would be greatly appreciated. -Minitman |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How To Detect A Negative Number In A Cell
If the OP wants to change the text colour for the whole row, rather than
just for that cell, then it'll need Conditional Formatting. Formula Is/ =$M1<0 -- David Biddulph "Stefi" wrote in message ... Select column MCell formattingCategory:NumberSelect one of red patterns for negative numbers Regards, Stefi "Minitman" ezt írta: Greetings, I am trying to detect whether the value in cell M for each row has a negative number. If it does I need to change the text color for that row to red. Any help, insights or links would be greatly appreciated. -Minitman |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How To Detect A Negative Number In A Cell
Hey Stefi,
Thanks for the reply. Since I need the entire row to change, cell formatting won't work. my problem seems to be in the formula I tried to work in Conditional Format: =$M2<0 I can't get this formula to work in a test cell or in CF: =IF($M2<0,"NEGATIVE","POSITIVE") I do appreciate the attempt. -Minitman On Thu, 13 Mar 2008 01:54:00 -0700, Stefi wrote: Select column MCell formattingCategory:NumberSelect one of red patterns for negative numbers Regards, Stefi „Minitman” ezt írta: Greetings, I am trying to detect whether the value in cell M for each row has a negative number. If it does I need to change the text color for that row to red. Any help, insights or links would be greatly appreciated. -Minitman |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How To Detect A Negative Number In A Cell
Hey David,
Thanks for the reply. Nice catch on the whole row. There seems to be a problem with that formula (=$M2<0) That formula is what I tried at first in CF. I know how to get the color I need if the formula is working. That formula seems to be the culprit. So to test the formula, I moved back to the sheet and chose a column to test the formula. In the first row (row 2), I placed: =IF($M2<0,"NEGATIVE","POSITIVE") I then copied it down for 10 rows (it automatically advanced the row number), I paced both positive and negative numbers (along with a zero in one row for testing) in the test rows M column. They all came back "POSITIVE" which is to say they all returned FALSE. Any idea as to what is wrong with this formula? -Minitman On Thu, 13 Mar 2008 11:10:16 -0000, "David Biddulph" <groups [at] biddulph.org.uk wrote: If the OP wants to change the text colour for the whole row, rather than just for that cell, then it'll need Conditional Formatting. Formula Is/ =$M1<0 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How To Detect A Negative Number In A Cell
It sounds as if you've got text, rather than numbers, in your column M.
To convert to numbers, try copying a blank cell, then select column M and use Edit/ Paste Special/ Add. -- David Biddulph "Minitman" wrote in message ... Hey David, Thanks for the reply. Nice catch on the whole row. There seems to be a problem with that formula (=$M2<0) That formula is what I tried at first in CF. I know how to get the color I need if the formula is working. That formula seems to be the culprit. So to test the formula, I moved back to the sheet and chose a column to test the formula. In the first row (row 2), I placed: =IF($M2<0,"NEGATIVE","POSITIVE") I then copied it down for 10 rows (it automatically advanced the row number), I paced both positive and negative numbers (along with a zero in one row for testing) in the test rows M column. They all came back "POSITIVE" which is to say they all returned FALSE. Any idea as to what is wrong with this formula? -Minitman On Thu, 13 Mar 2008 11:10:16 -0000, "David Biddulph" <groups [at] biddulph.org.uk wrote: If the OP wants to change the text colour for the whole row, rather than just for that cell, then it'll need Conditional Formatting. Formula Is/ =$M1<0 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How To Detect A Negative Number In A Cell
Hey David,
Thanks for the reply. That was the problem. Thank you very much. -Minitman On Thu, 13 Mar 2008 15:11:17 -0000, "David Biddulph" <groups [at] biddulph.org.uk wrote: It sounds as if you've got text, rather than numbers, in your column M. To convert to numbers, try copying a blank cell, then select column M and use Edit/ Paste Special/ Add. |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How To Detect A Negative Number In A Cell
Glad it worked for you.
-- David Biddulph "Minitman" wrote in message ... Hey David, Thanks for the reply. That was the problem. Thank you very much. -Minitman On Thu, 13 Mar 2008 15:11:17 -0000, "David Biddulph" <groups [at] biddulph.org.uk wrote: It sounds as if you've got text, rather than numbers, in your column M. To convert to numbers, try copying a blank cell, then select column M and use Edit/ Paste Special/ Add. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Negative number morphing to a cell code | Excel Worksheet Functions | |||
cell to show ' 0 ' , or nothing at all, if the sum is a negative number | Excel Worksheet Functions | |||
make cell entries a negative number | New Users to Excel | |||
2003= negative number&2004= negative number How Do I Calculate gro | Excel Worksheet Functions | |||
how to change the state of a number in a cell from negative to po. | Excel Discussion (Misc queries) |