Hi
not sure I understand you but the code would change all entries in
column C to a negative number if the adjacent cell in column B contains
your criteria?

--
Regards
Frank Kabel
Frankfurt, Germany
"CWit " schrieb im Newsbeitrag
...
Thanks for the quick response, the code works but it only allows one
number in column C to be negative at a time so say I have 25 rows in
Column C with that condition only one converts to a negative number.
I'm trying to add all those numbers in Column C up so I need all
corresponding cells to turn negative so my total is correct. Thanks


---
Message posted from http://www.ExcelForum.com/