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

 

[Fluff]

How about something like
=A1="Flex Wk"&CHAR(10)&"1"

 

[photojon]

Thanks for the quick reply. Can you provide a little background on the =A1= part? Is this part of the conditional formatting structure or what I should experiment on with a search? I tried doing a search on "Flex Wk"&CHAR(10)&"1" and that didn't work. thanks again.

 

[Fluff]

What is the range of cells that you want this to work on?

 

[photojon]

A1 to AS55

 

[Fluff]

In that case select those cells > Home Tab > Conditional Formatting > New rule > Use a formula > enter the formula I supplied > select a format > Ok.
You may need to add a space or two into the formula depending on what you exact values are.

 

[photojon]

Thanks again for all the help. It still does not appear to be working. To test it I entered the following in a cell (within the working range) "Flex Wk <pressed alt enter> 1" (where the alt and enter is just the key strokes, not the actual text). It visually appears to match the other data in the sheet but wanted to try it on a cell whose contents I knew for certain. I tried your suggested formula padding a space before the "1" and also without a space before the "1". Any other suggestions? Thanks again

 

[Fluff]

Is there a space after the Wk & before the linefeed?

 

[photojon]

Unfortunately not. I retyped my "sample entry" with no space after the "Wk", pressed alt-enter, and then typed "1" leaving no additional spaces (the only space is between Flex and Wk)

 

[Fluff]

Put the formula into a blank cell & point it at the cell with your sample value, does it show TRUE

Excel 2013/2016
	A	B
1	Flex Wk 1	TRUE
sheet1

Cell Formulas
Range	Formula
B1	=A1="Flex Wk"&CHAR(10)&"1"