Conditional formattimng where I can change the color of the icon sets

So I am pretty sure this isn't possible but I figured I would ask just in case anyone has an amazing idea. currently I have a sheet that shows positive, negative numbers and zero. In my case positive numbers are bad and negative numbers are good and zero is zero. If I use the arrow icon sets that show a red down arrow for negative numbers and a green up arrow for positive numbers. I am trying to find a way through either VBA, formulas, or whatever anyone can can up with where when the number is negative it shows a down green arrow instead of a down red arrow and when the number is positive it shows an UP red arrow instead of an up green arrow. My boss wants arrows for some reason so there is no give on that unless its just impossible. I no I can just make an arrow using the shapes but that would be time intensive because we are talking hundreds of rows of data.

Can't be done with the icon sets, but here's one workaround, which requires an extra column for the arrows.

Assuming value of interest in A1, enter this formula in B1, and fill down.

=IF(A1<0,CHAR(234),CHAR(233))

Apply the 'wingdings' font to column B.

Next apply conditional formatting to column B, using 2 formulas as rules.

First rule, changes font colour to green.

=B1=CHAR(234)

Second rule, changes font colour to red.

=B1=CHAR(234)

There are a couple of other arrow styles using the same font.

Yeah that's what I figured its a great work around. Thanks!!