Solution Found. Using the OnCellFormatting Event.
http://www.awprofessional.com/articles/article.asp?p=446453&seqNum=5&rl=1