Finding Carriage returns with Conditional Formatting

[Fyresparxx]

I have an excel sheet that occasionally uses carriage returns in certain cells to display multiple lines of data. These cells are merged for formatting reasons and this cannot be changed. Merged cells cannot use auto-fit row height, so it must be done manually so all data will be visible.

I'm not interested in find and replace, I just want to set up conditional formatting to find a hidden carriage return and highlight the cell so it can have its height adjusted. I can't seem to figure out how to set up the CF window to find hard returns.

 

[wigi]

Hello

For example, conditional formatting:

=ISNUMBER(FIND(CHAR(10),A1))

if you apply this to range with cell A1 selected. If not, change the formula to accommodate.

 

[Fyresparxx]

Thanks for that. I wasn't sure what to call a carriage return in a formula and had found information about alt codes and odd key combinations and none of it worked. This works wonderfully, thanks.

 

[wigi]

You're welcome, thanks for the feedback!