Conditional Formatting only top line of cell

I have a worksheet with conditional formatting applied. My formula works to change the cell color, font color, and strike-through the font if a "yes" answer is indicated. It all works well EXCEPT that the font color and strike-through ONLY apply to the top line on my cell.

Each cell has a title line, and a few paragraphs in it, with separations between the title line and the paragraphs. I kind of like having the title line a different font, but when it's time to strikethrough I want ALL of the text struck through.

Any ideas on how to do this? Here's an example of my conditional formatting,

Please Login or Register  to view this content.

and a sample of the text in a cell:

Please Login or Register  to view this content.

You can't partially conditionally format a cell....


Maybe with some VBA... but not with native Excel.

Please re-read my post. Perhaps I phrased it awkwardly, but the problem is that Excel IS partially applying conditional formatting, and I want it to apply the conditional formatting FULLY. Excel now is applying the font attributes of the conditional formatting ONLY to the top line; I want it applied to all of the text in the cell.

Also, one thing I think may be the culprit, is that the Title in the cell (top line) I manually format as italic, whereas the rest of the font is non-italic. If I make the italics-setting consistent in the cell, the conditional formatting works properly. But I'd like to keep the top line italicized to make it stand out. Any good ideas?

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

Hmmm.. interesting.. the fact that you manually partly formatted the cell to italics... "confuses" the conditional formatting.. I guess because it looks at maybe the first character of the cell to check the format and to see whether it needs to change it or not... and not the entire cell content.... I tested it by just changing the first character back to normal font, then the strike-through only applies to that first character...

Not sure how to make it ignore the already applied format...

Maybe like this. Code goes in the Sheet module.

Please Login or Register  to view this content.

Sorry about downplaying it .. I know it is frustrating... but I also discovered that in XL2007, it formats as you desire (i.e. the whole thing strikes through and leaves first line italicized)... so probably a 2003 bug or something that got noticed and fixed later....