Thread: Gridlines
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
GS[_2_] GS[_2_] is offline
external usenet poster
 
Posts: 3,514
Default Gridlines

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