yeh i have a custom formula that turns cell color into some numeric code. then use sumif formula to add it all up. if you need it, lemme know and i'll get it from work.
actually my formula is from "borrowed" from jani's link above.
Last edited by jclau00; Apr 18, 2007 at 10:26 PM.