You can also use the Format Painter. When you copy formats, CF rules are included. That wouldn't require editing any formulas. But I thought I did apply to all columns with dates.