may be this ??

in col B put this forumula =IF(B20,"",B2)

select the col A & then go format | conditinal format | choose formula
is :=B2=C2 | format | font tab | choose the white color | ok | ok


On Sep 26, 4:13*pm, Sojo wrote:
I am writing a macro to automate several processes. *I have the following
table where column A has positive and negative values and column B is blank. *
I need a formula that will find all the negative values in column A and move
them to column B. *In essence, it needs to say if number in column A < 0,
then cut it and paste it into column B.

* * * * *A * * * * * * * * *B
1. * Original * * Negative
2. * 3.72545 * *
3. * 3.4584 * *
4. * *3.1071 * *
5. -0.460399 * *
6. -0.803222 * *
7. -1.12457 * *