please see this thread:

http://www.excelforum.com/excel-work...or-1-cell.html

I can get the condition to work fine manually but once I put it into a macro, it does not work properly.... doesnt make sense.......