is there some way to 'easily' copy over all conditional formatting rules, and formulas from column 'a' in 'sheet 1' to column 'a' in other sheets. i know i can just 'copy' sheet 1 and all rules should copy as well, however, sheets 2-20 already have tons of information in then and i cant just 'start over'. does this make sense to anyone?