I have created another example for Event Change coloring,
this one will color the entire row based on the content of a column.
http://www.mvps.org/dmcritchie/excel/event.htm#case_row
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages:
http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:
http://www.mvps.org/dmcritchie/excel/search.htm