Hi,

Try this site it will help you and as for your cell updating i thin
you need to right click on the worksheet tab and chose view code in th
box where it says general choose worksheet and the one on the lef
choose selectionchange paste your code in here and everytime a cell i
selected or you criteria is met it will run!

I'm new to programming but some kind person on here gae me that piec
of advice it may work for u!

Simon

http://www.cpearson.com/excel/colors.htm This guy's site has some goo
info on colours

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