you seem to have excel 2007 not 2003 as in your profile so cf is done slighly differently.
its not easy to describe in text you need to have a look at how its done.
http://www.contextures.com/xlCondFormat02.html pre 2007
http://www.cpearson.com/excel/cformatting.htm pre2007
http://www.free-training-tutorial.co...ormatting.html 2007
http://techblissonline.com/condition...in-excel-2007/