Hi Mary,
You can use the Format Painter (paintbrush toolbar icon) to change the
formatting. Used for normal cell formatting, but it copies the Conditional
Formatting, and number (/text) formatting as well.

It is best to format the entire column when you first created the C.F.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"MaryMalone" wrote in message ...
I want to copy the formatting I have for one cell down the rest of the
column. How do I do that? I dont want to have to set each one up individually.

Thanks