Conditional Formatting - v 97-2003 - part of cell will not format

[jrich]

I have a worksheet that was created using Excel 2010, but am needing to insert it into some other worksheets that were created using 2003. I have saved it as a 97-2003 document, but now a portion of my conditional formatting will not work. I have some instructions for a certain field that are in the empty space next to this field. When a selection is made in the field, the instructions are supposed to disappear (I have font color set to white when condition is met). Now that it's saved as 97-2003, the first word or two of the instructions are formatted correctly but the following words are not.

I cannot upload the file due to sensitive information contained in it, but here's an example of what I am seeing.

EXAMPLE:

User makes choice in this field Here are directions that tell them choice to make

Once the choice has been made, the portion above in italics is supposed to turn white and not be
seen. "Here" turns white as it should but "are directions..." remains red which is the color I have it set to.



Anyone have an idea??? Is this just something that won't work properly since I went from one version of Excel to another???

Thanks!

[Special-K]

Is this Conditional Formatting as per an option within Excel or is this done via a macro? I suspect the latter.

[jrich]

No, it was done with the Conditional Formatting option in Excel.

[Norie]

You can't use conditional formatting to change the format of just part of a cell.

Are you sure this isn't being done with code?

[jrich]

That's my problem - I don't want it to change just part of the cell, I want it to change the whole cell - but it is in actuality only changing part of the cell and not the whole thing.

[Norie]

There's definitely no code involved?

What is the conditional formatting that's being applied?

Could you attach a sample workbook without sensitive data?