Try using the "Format Painter" tool (yellow paintbrush) from the toolbar.

Click in the cell with the CF,
Click on the paintbrush,
Click in the first cell you want copied, and drag down.

If the cells you want to CF are not contiguous,
*Double Click* on the paintbrush,
And then simply click in each cell that you want to CF.

Hit <Esc to exit the format copy mode.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"bman342" wrote in message
...
I am setting up a very simple, one-step, conditional format to hide a cell
if
it is displaying an error.

The formula is: =iserror(relative cell ref)
The format is: font color = white

I then try to copy those cells, but the whole range turns white.
I then cannot even manually adjust the font color for those cells, as they
still render as white.

And oddly even if I manually retype the whole conditional formatting (in a
cell where I attempted to copy the conditional formatting) it still won't
render properly. I have to delete the conditional formatting, and then
retype.

Can anyone give me some pointers?

Thanks,

-b