Help with conditional formatting

[HH]

Hi, I'm using Excel 2007 and I'm using conditional formatting to highlight
duplicate cells. This works great. The only problem is, this is a huge
spreadsheet, and the conditional formatting seems to really slow down of
scrolling through the worksheet. I was really hoping to be able to convert
the conditional formatting to "regular" formatting, meaning I would like to
keep the color of the cell and/or the text and remove the "conditional" part
that seems to be slowing everything down, but this doesn't seem possible.

I tried to copy and paste the data into Word, thinking that I could then
copy and paste it back into Excel, but the whole thing is so huge that it
just hangs when I'm trying to paste into Word.

If it isn't possible or easy to convert the conditional formatting to
regular formatting, is it at least possible to "Go to" or "Find" each cell
with conditional formatting so I could at least move quickly from one cell to
the next and see where the duplicates are? My attempts to do this so far
have failed.

I don't work with conditional formatting much so maybe there's a simple
solution that I'm missing. Thanks in advance for any help.

 

[Carim]

Hi,

F5
Special
Conditional Formating

will allow you to select all your cells in one go .... to copy paste
special ...

HTH

 

[HH]

Hi, thanks for your reply. I tried what you suggested but whenever I try to
paste special all the formatting disappears unless I do a regular paste or
choose "All" from the paste special menu. But if I do the latter then the
formatting applied is still conditional formatting.

Is there something else I have to do to get it to work? I think I've tried
all the options in the paste special box.

Thanks for any help.

 

[Carim]

Sorry ... I read your initial post too quickly ...

You are facing quite a tricky issue ...
Keep format generated by conditional formatting while deleting
conditional formatting rules ...
A good starting point would be Chip's site :
http://www.cpearson.com/excel/CFColors.htm

HTH

 

[HH]

Hi, thanks for the link. There seems to be a lot of good information on that
site. I tried using some of the conditional formatting functions listed
there, but I can't seem to get them to work right. I've mostly been trying
to use the COLOROFCF function but when I do, sometimes I get #NAME? errors,
sometimes I get #VALUE! errors, and sometimes I do get a number, but I don't
think it's correct because it gives the same number to cells both with and
without conditional formatting.

I guess maybe there is no easy answer to this. I'm just kind of puzzled
because I keep getting so many different results whenever I try to use these
functions.