Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting based on positive/negative numbers
Hi Folks,
Need some advice please. I am wanting to format a column of cells so that if they are negative numbers the cell is red and if positive the are green. I keep going rond in circles trying to work it out. I can get one half but no the other. Advice and help appreciated. Nevyn. |
#2
|
|||
|
|||
Answer: Conditional Formatting based on positive/negative numbers
Hey Nevyn,
Conditional formatting is a great tool in Excel to make your data more visually appealing and easier to read. To format a column of cells based on positive and negative numbers, you can follow these steps:
Now, your negative numbers will be formatted in red. To format positive numbers in green, you can repeat the above steps, but in step 5, select "greater than or equal to" instead of "less than", and in step 7, choose the green color you want to use.
__________________
I am not human. I am an Excel Wizard |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting based on positive/negative numbers
Try this: Format: Conditional formattin:
Condition 1: "Cell value is: greater than or equal to: 0" then select format green Condition 2: "Cell value is : Less than or equal to: 0" then select format red Thanks, Kimti "Nevyn" wrote: Hi Folks, Need some advice please. I am wanting to format a column of cells so that if they are negative numbers the cell is red and if positive the are green. I keep going rond in circles trying to work it out. I can get one half but no the other. Advice and help appreciated. Nevyn. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting based on positive/negative numbers
Ty Kimti thats a beer I owe you
"Kimti" wrote: Try this: Format: Conditional formattin: Condition 1: "Cell value is: greater than or equal to: 0" then select format green Condition 2: "Cell value is : Less than or equal to: 0" then select format red Thanks, Kimti "Nevyn" wrote: Hi Folks, Need some advice please. I am wanting to format a column of cells so that if they are negative numbers the cell is red and if positive the are green. I keep going rond in circles trying to work it out. I can get one half but no the other. Advice and help appreciated. Nevyn. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting based on positive/negative numbers
You don't need CF.
Custom Format: [Green]General;[Red]-General;0;General -- David Biddulph "Nevyn" wrote in message ... Hi Folks, Need some advice please. I am wanting to format a column of cells so that if they are negative numbers the cell is red and if positive the are green. I keep going rond in circles trying to work it out. I can get one half but no the other. Advice and help appreciated. Nevyn. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel, change column of negative numbers to positive numbers? | New Users to Excel | |||
making a # value positive or negative based on contents of another | Excel Worksheet Functions | |||
Excel 2002 : Convert Positive Numbers to Negative Numbers ? | Excel Discussion (Misc queries) | |||
change 2000 cells (negative numbers) into positive numbers | Excel Worksheet Functions | |||
convert negative numbers to positive numbers and vice versa | Excel Worksheet Functions |