HTML code for a single line feed

T. Valko

Well-known Member
Joined
May 9, 2009
Messages
16,623
Hi Folks!

As near as I can tell this html code tag (without the quotes) produces a double space line:

<"br /">

What's the code for a single space line?
 
The br tag is actually the HTML for a single line space.
 
The br tag is actually the HTML for a single line space.
In this post:

http://www.mrexcel.com/forum/excel-questions/654035-conditional-formatting.html#post3243192

This text was copied and pasted into the reply:

Select the *entire* range _____ starting from cell __.
Cell __ will be the active cell. The active cell is the
one cell in the selected range that is not shaded. The
formula will be relative to the active cell.
<br />
Goto the Home tab-Styles-Conditional Formatting-Manage rules-
New rule-Use a formula to determine which cells to format
<br />
Enter this formula in the box below:
<br />
xxxxx
<br />
Click the Format button
Select the desired style(s)
OK out

As you can see in the post the line feeds are double spaced.

So, how I can get that to only enter a sinlge line feed?
 
This is the HTML for that section of the page in the link.
HTML:
Here are the steps to take...<br />
<br />
Select the *entire* range C6:AG6 starting from cell C6.<br />
Cell C6 will be the active cell. The active cell is the<br />
one cell in the selected range that is not shaded. The<br />
formula will be relative to the active cell.<br />
<br /><br />
Goto the Home tab-Styles-Conditional Formatting-Manage rules-<br />
New rule-Use a formula to determine which cells to format<br />
<br /><br />
Enter this formula in the box below:<br />
<br /><br />
=COLUMN()=MAX(($C$7:$AG$18=MAX($C$7:$AG$18))*COLUMN($C$7:$AG$18))<br />
<br /><br />
Click the Format button<br />
Select the desired style(s)<br />
OK out
 
This is the HTML for that section of the page in the link.
HTML:
Here are the steps to take...<br />
<br />
Select the *entire* range C6:AG6 starting from cell C6.<br />
Cell C6 will be the active cell. The active cell is the<br />
one cell in the selected range that is not shaded. The<br />
formula will be relative to the active cell.<br />
<br /><br />
Goto the Home tab-Styles-Conditional Formatting-Manage rules-<br />
New rule-Use a formula to determine which cells to format<br />
<br /><br />
Enter this formula in the box below:<br />
<br /><br />
=COLUMN()=MAX(($C$7:$AG$18=MAX($C$7:$AG$18))*COLUMN($C$7:$AG$18))<br />
<br /><br />
Click the Format button<br />
Select the desired style(s)<br />
OK out
Aha!

Ok, I see what needs to be done. Tried it (in that thread) and this time it worked as I wanted it to!

Thanks for the hints!
 

Forum statistics

Threads
1,221,556
Messages
6,160,476
Members
451,649
Latest member
fahad_ibnfurjan

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