You can use the "Format Painter" toolbar icon to copy Conditional Formatting,
but it would be a lot better to format everything that it might apply to
ahead of time as long as the range is continuous it should be more
efficient. (looks like a paint brush, not the paint buckets).
I have a page on Conditional Formatting
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.yqcomputer.com/
Search Page: http://www.yqcomputer.com/