Hi everything,

My subject pretty much sums up what I need a macro to do,

I need it to look down a column at the red cells only and if it finds
a red cell that is not been -100000 and 100000 then highlight the
entire row blue.

Is this possible?

I hope someone can help

thanks so much in advance,

Andrea