Finding Carriage returns with Conditional Formatting

Fyresparxx

New Member
Joined
Mar 21, 2014
Messages
18
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.
 

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"
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.
 
Upvote 0
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.
 
Upvote 0
You're welcome, thanks for the feedback!
 
Upvote 0

Forum statistics

Threads
1,215,452
Messages
6,124,914
Members
449,195
Latest member
Stevenciu

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top