Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do i get excel to format a cell for a negative result.
Hi,
Can someone please tell me how i can get excel to format the cell when the result is negative. eg 2 - 3 = -1 therefore the cell would turn red. |
#2
|
|||
|
|||
in menu format-cells-number-
choose whichever format for negative n;umber Cisco wrote in message ... Hi, Can someone please tell me how i can get excel to format the cell when the result is negative. eg 2 - 3 = -1 therefore the cell would turn red. |
#3
|
|||
|
|||
Hi Cisco
Select the range where you want this t apply, click on Format|Cells, and under the Numbers Tab, choose the type you want. You'll see that you can select either positive or negative as red, and also as black -- ve_2nd_at. Randburg, Gauteng, South Africa "Cisco" wrote: Hi, Can someone please tell me how i can get excel to format the cell when the result is negative. eg 2 - 3 = -1 therefore the cell would turn red. |
#4
|
|||
|
|||
Thanks Kassie,
can't believe it was so easy. Thought i need an "if" formula. thanks "Kassie" wrote: Hi Cisco Select the range where you want this t apply, click on Format|Cells, and under the Numbers Tab, choose the type you want. You'll see that you can select either positive or negative as red, and also as black -- ve_2nd_at. Randburg, Gauteng, South Africa "Cisco" wrote: Hi, Can someone please tell me how i can get excel to format the cell when the result is negative. eg 2 - 3 = -1 therefore the cell would turn red. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I format a cell in excel based on a list of about 20 items? | Excel Discussion (Misc queries) | |||
Format a Cell in Excel as an IP address field | Excel Discussion (Misc queries) | |||
Excel cell format | Excel Discussion (Misc queries) | |||
How do I unhide the cell format function in Excel 2000 | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |