I am having trouble formatting negative numbers. I have two columns of numbers and I want to highlight the one that is greater. If they are negative it will ignore the negative. For example see below. I need a formula that works. I used =ifb1>d1 in conditional format to highlight f b1 is greater. But like I said it ignores the negative as you can see in b4 and b6. Any help will be appreciated.
<colgroup><col width="83" style="width: 62pt; mso-width-source: userset; mso-width-alt: 3035;">
<col width="64" style="width: 48pt;" span="3">
<tbody>
</tbody>
A | B | C | D |
$1,004,476 | -8.18 | $51,212 | 1.71 |
$3,946,561 | -8.53 | $365,070 | 4.54 |
$3,776,271 | -1.15 | $271,294 | -1.45 |
$3,728,023 | -0.66 | $38,056 | -0.52 |
$2,635,464 | -1.98 | $119,067 | -2.9 |
$1,519,864 | -7.65 | $139,199 | -2.72 |
$514,896 | -5.21 | $18,258 | 8.01 |
$255,818 | -15.14 | $13,087 | 6.24 |
$956,084 | -9.07 | $96,793 | -0.66 |
$1,258,367 | -16.1 | $42,305 | 14.93 |
$2,751,372 | -4.03 | $148,035 | 4.31 |
$447,579 | -6.52 | $53,733 | -1.5 |
$2,692,657 | 15.69 | $179,203 | 0.73 |
$5,958,192 | -8.08 | $254,835 | 6.35 |
$3,393,899 | -6.57 | $122,395 | 0.06 |
$1,035,032 | -4.81 | $93,237 | -17.59 |
$2,277,558 | -5.15 | $148,912 | -7.55 |
$348,991 | -11.06 | $3,421 | -22.91 |
$25,415 | 26 | $0 | 0 |
$720,022 | -7.24 | $37,790 | -10.94 |