Gridlines

[Stephen Wolstenholme]

How can I have grid lines in just part of a worksheet? I don't want
them on over all of the worksheet.

Steve

 

[lhkittle]

How can I have grid lines in just part of a worksheet? I don't want

them on over all of the worksheet.



Steve



--

EasyNN-plus. Neural Networks plus. http://www.easynn.com

SwingNN. Forecast with Neural Networks. http://www.swingnn.com

JustNN. Just Neural Networks. http://www.justnn.com

Hi Steve,

One way...

Home Tab > Font > Fill color (paint bucket) > Theme colors > White.

HTH
Regards,
Howard

 

[lhkittle]

Hi Steve,



One way...



Home Tab > Font > Fill color (paint bucket) > Theme colors > White.



HTH

Regards,

Howard

I should have said "select the area you want the grid lines hidden" then color white.

H'wd

 

[GS]

Stephen Wolstenholme presented the following explanation :

How can I have grid lines in just part of a worksheet? I don't want
them on over all of the worksheet.

Steve

You can turn Gridlines off and use dotted borders to 'simulate' the
gridlines where you want.

This can be managed via ConditionalFormatting for a series of cells
based on input into any specified cell. For example, if you want
simulated gridlines in B10:H10 when a value is entered in B10, select
the range and specify the following formula as the CF criteria:

=LEN($B10)

HTH

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion