Combine conditional sections and conditional values in custom formats?

[JenniferMurphy]

I can have different formats for positive, negative, and zero values: +0;-0;=0.

And I can have different formats up to two conditional value ranges: [<1]0.00;[<10]0.0;#,##0.

Is there any way to combine the two so that I can both the +/-/= prefix and the variable number of decimal places?

I would like the numbers in the left column formatted as shown in the right column:

[TABLE="class: grid, width: 200"]
<tbody>[TR]
[TD="align: right"]-23.45[/TD]
[TD="align: right"]-23[/TD]
[/TR]
[TR]
[TD="align: right"]37.52[/TD]
[TD="align: right"]+38[/TD]
[/TR]
[TR]
[TD="align: right"]7.83[/TD]
[TD="align: right"]+7.8[/TD]
[/TR]
[TR]
[TD="align: right"]-1.28[/TD]
[TD="align: right"]-1.3[/TD]
[/TR]
[TR]
[TD="align: right"]0.737[/TD]
[TD="align: right"]+0.74[/TD]
[/TR]
[TR]
[TD="align: right"]-0.482[/TD]
[TD="align: right"]-0.48[/TD]
[/TR]
[TR]
[TD="align: right"]0[/TD]
[TD="align: right"]=0[/TD]
[/TR]
</tbody>[/TABLE]

Can this be done?

 

[Tetra201]

Try applying these three:

Custom format: +0;-0;=0
Conditional formatting: rule =AND(A1>-10,A1<10), number format +0.0;-0.0;=0
Conditional formatting: rule =AND(A1>-1,A1<1), number format +0.00;-0.00;=0

 

[JenniferMurphy]

Try applying these three:

Custom format: +0;-0;=0
Conditional formatting: rule =AND(A1>-10,A1<10), number format +0.0;-0.0;=0
Conditional formatting: rule =AND(A1>-1,A1<1), number format +0.00;-0.00;=0

Thanks. Clever solution, as usual. I take it that, as I feared, there is no way to do this using only a custom format, right? I have never been able to control the conditional formats. I always end up with dozens, if not hundreds, of rules as I inevitably move rows and columns around.