Highlighted Cells Apply Conditional Format using Macro

[wickitom]

I need a macro or the commands that when bunch of cells are highlighted (cells have numbers between -100 to 100) I can apply a conditional formating to them, the ones which are <0 would be blue and if any of the numbers are are between -1 to -100 and 1 to 100 bold them.
Basically, I paste bunch of numbers, since the selection is highlighted apply the format then.

Is there anyway.

Tom

 

[wickitom]

Forgot to add, I need a macro commands to do it