# Formatting Problem Driving Me Crazy

#### RAF1112

##### Board Regular
Hello all,

I am trying to format a percentage...but with no luck. I want the percentage to have 2 decimal places and the % if greater then zero but show nothing in the cell if the result is zero. Is this possible?

Thanks!

Last edited:

### Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

#### PCL

##### Well-known Member
When value is 0 font and pattern are white.

#### Diablo II

##### Well-known Member
ok in the cell that will = put =IF(I6,I6,"") change the row and colums as you need it. then in that cell right click and then format cell,then pick the number tab and pick you Decimal. the way this works is

if (the cell you are pulling from, if true then that cell, if false then " ") the "" makes it empty.

#### Kelbo

##### Board Regular
Assuming that the value in the cell is the result of a calculation then use a formula of this type:

=if((calculation)>0,(calculation),"")

eg. =IF((A1-B1)/B1>0,(A1-B1)/B1,"")

Hope this helps,

Kelbo

#### RAF1112

##### Board Regular
The only problem is that I have multiple colored (fill) cells I want to apply this too....so I could do that but would have to specify the color text for each different color fill....sort of a pain.

#### RAF1112

##### Board Regular
sorry...posted before I saw the additional suggestion. I think that will work....thanks!!

#### Diablo II

##### Well-known Member
ops frogot the % =IF(I6,I6%,"") i use j16 if i16 is a number then J16= i16 as a %

Replies
2
Views
408
Replies
1
Views
248
Replies
21
Views
394
Replies
4
Views
276
Replies
15
Views
442

1,191,532
Messages
5,987,127
Members
440,080
Latest member
drhorn4908

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back