Conditional Format STOPS at linefeed (line feed, line break)

P

pbateson

New Member
Joined
Dec 19, 2013
Messages
1
In 2003 Conditional Format would format (font) the whole cell. It appears that 2010 stops the formatting after a linefeed? Is this right? ie. is it my configuration/system? Is it configurable? Is there a workaround? Thanks very much.
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.
You must log in or register to reply here.

Similar threads

D
  • Solved
How to control formatting of unprotected cells in a protected sheet? Ideas?
Replies
2
Views
326
Dman333
D
J
  • Solved
Conditional Format Top Cell - with Formula Issue
Replies
3
Views
207
dreid1011
dreid1011
C
  • Solved
Highlight entire rows in used range where any cell contains searched text
Replies
5
Views
408
CorrieAnn
C
P
  • Question Question
Conditional formatting using formula to select color from another cell
Replies
4
Views
435
handysmurf
H
D
  • Question Question
Trying to force people to not use a comma (even when pasting) or enter a number in a specific format
2 3
Replies
22
Views
756
Peter_SSs
Peter_SSs

Forum statistics

Threads
1,223,238
Messages
6,170,939
Members
452,368
Latest member
jayp2104

Share this page

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