Ok, it sounds like you just need to make the conditional formatting
reference a relative reference.

=ISERROR(H4)

I even looked at Paste Special to see if there was a
'Conditional Formatting' check box

There is a Paste SpecialFormats and this will include any conditional
formatting. That's how I copy formats. I've never used the Format Painter.
In fact, I took it off my toolbar.

--
Biff
Microsoft Excel MVP


"bman342" wrote in message
...
I have a range h4:h100, so I set up the conditional formatting in h4 and am
copying h4, and pasting it into h5:h100. I am copying/pasting the entire
cell
contents (I even looked at Paste Special to see if there was a
'Conditional
Formatting' check box). So the pasting is copying the Conditional
Formatting,
but copying the absolute cell ref, and not making it relative (so $h$4
shows
up in every conditional format formula). BTW, I copied with both the
paste
function, and the drag function, and the same result.

The odd thing is that when I retype the proper cell reference, it still
renders the font white, when it shouldn't. The only way I can make it work
is
if I delete the Conditional Formatting, and retype it. And even though it
is
typed exactly as it was, it now renders properly.

I am now using =if(iserror([ref]),"",[ref] which which also delivers the
desired results, but am still perplexed by the behavior of Conditional
Formatting when copied.

"T. Valko" wrote:

What cells have the conditional formatting?

What cells are you copying? Are you copying just the formatting or the
entire cell contents?

Where are you pasting after the copy?

--
Biff
Microsoft Excel MVP


"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