Conditional formatting on cells that contain a line feed

[photojon]

Greetings,

I have a simple single worksheet that contains all text (no formulas, VBA, etc). I am trying to create a conditional format for cells that contain "Flex Wk (linefeed) 1" and am having issues. Here are the experiments I have tried. I am able to create conditional formatting for all the cells that contain the number "1". I am also able to conditional format cells that contain "Flex Wk". I have also tried just doing a simple "Find" which works on "Flex Wk" but not "Flex Wk 1". Visually I observe the linefeed between the "Wk" and the "1". My internet searches reference CHAR(10), CHAR(13), ctrl+j, ALT 0010, etc. I have tried inserting these between the "Wk" and "1" and not of the searches find the cells. I am using Excel 2016.

Thanks
Jon

 

[photojon]

Thanks. That does help. I thought with conditional formatting, it was just looking at the content of the cell and determining if that cell matches the criteria and if so formatting. From the example here it appears that with conditional formatting, the condition and the cell that is formatted can be two different cells. While I use Excel a lot, conditional formatting is pretty new to me and I'm sure (like most things in excel) this nuance provides a ton of power once I get my head wrapped around it. Thanks again to all for the help!

 

[jtakw]

You're welcome, glad it helped clarify things a bit for you.

Yes, you have to specify Where the CF formula rule looks, but this Only applies when you use a Formula as a CF rule, the Other default rules defaults to the subject cell.

So again, when you are using a Formula as a CF rule, you Always have to specify what Cell/Cells that formula looks to.

Happy New Year.