Compatibility checker driving me crazy

[roscoe]

Keeps telling me that 2 cells contain formatting that is not supported by the selected file format. Problem is it won't tell me which ones?

The help button shows a picture of the dialog box with a "find" link, but that's not appearing for me.

Any idea how to find out?

 

[roscoe]

More data, different cell.

Error says: "Some cells have overlapping conditional formatting ranges. Earlier versions of Excel will not evaluate all of the conditional formatting rules on the overlapping cells. The overlapping cells will show different conditional formatting."

First, what the heck does this even mean? Overlapping with...what? [I want to find the guy who wrote this and smack him.]

I have a conditional formatting statement in cell M36 that says "=ISNA(MATCH(M36,bracket25,0))"
[bracket25 is a named range of two names. If the name in M36 is not one of those names, the do this format.] If I delete this format, the error goes away. Cannot figure out why.

 

[roscoe]

Well, I made the errors go away but I had to stop spreading a conditional format over multiple cells but create a new one each time. What a PITA.

 

[mole999]

can you not just save as 2007 version, and that will stop some of the issues

 

[roscoe]

ADVERTISEMENT

I'd love to but I need to give it to others that have older versions

 

[mole999]

then your coding has to reflect what 2003 will do happily and not 2007

bearing in mind 2003 can only handle 3 condition's per cell

i agree it drives me nuts

I would look at installing 2003 on your machine and developing there

 

[roscoe]

I realize 2003's limitations...in fact this workbook was originally built in 2003 and now being modified. The problem seems to be if I build ore than on CF and assign it to multiple cells. I know no single cell has more than three conditions, yet it's balking anyway. I had to remove multiple occurrences from all cells and recreate the CF for each cell individually. Very annoying.