Conditional formatting inserts a dashed line

sandz

New Member
Joined
Aug 9, 2012
Messages
2
Hello! This is my first post, after I've been lurking here for a year or two and finally have a problem I haven't been able to find.

Sheet has values that I've conditionally formatted. Nothing special...just quick formatted and provides a visual to what I'm doing. For some reason the first section is formatting with no issues, but the second and third sections are inserting dotted horizontal lines in about the first third of the cell. I need to remove the dotted/dashed line but have been unable to. The original sheet arrives from someone else so I'm not sure what they may have done in the way of formatting. I've removed the formatting, but to no avail. Also reformatted the cells, but nothign seems to work. The dotted lines appear to be where the conditional formatting data bar would begin. The other sections are fine.

So to sum up...conditional formatting inserts a dashed line into some cells, but not all. I need to remove this line. Pic located at the link below.

https://picasaweb.google.com/lh/photo/scLSSnuAUcn7QpSbUKK_zNMTjNZETYmyPJy0liipFm0?feat=directlink
 

Some videos you may like

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

sandz

New Member
Joined
Aug 9, 2012
Messages
2
Any ideas? I'm thinking I may just have to hand hack the entire sheet to get the formatting correct.
 

crm911

New Member
Joined
Apr 28, 2015
Messages
15
As the thread is quite old, this reply is for others such as myself who have just encountered the error. The difficulty in finding the answers is because a search for "dotted line" brings up lots of advice about page breaks, when the issue is a vertical dotted line in the middle of a conditionally formatted cell, not on its side.

In my case, the column with conditional formatting (data bar, gradient fill) gets populated only when another column has been populated. In other words, a templated worksheet with formulas but incomplete data will present this problem. Once I populated the column, the other column with conditional formatting was fixed.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,629
Messages
5,597,252
Members
414,133
Latest member
lucid33

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
Top