G Guest Apr 8, 2007 #1 ? how can I auto change colours in a frozen colum when a row or part row is completed