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.


"Carim" wrote:

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