Detect Negative numbers

try conditional formatting,
hilight the range
goto format,conditional formatting,
cell value
is less than
0

then select the conditions you want if the value is less than zero

Hi

If you want absolutely a macro, i purpose this solution

Please Login or Register  to view this content.

Raiby,

Please in future wrap your code. I've done it for you on this occassion

VBA Noob