| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Gridlines | Excel Discussion (Misc queries) | |||
| Gridlines are there, then Custom View, gridlines disappear in xl 2 | Excel Discussion (Misc queries) | |||
| not all the gridlines print; despite selecting/"gridlines" | Excel Discussion (Misc queries) | |||
| Row colors overlay the gridlines...how do I show gridlines? | Excel Discussion (Misc queries) | |||
| In Excel, gridlines won't print--File,PageSetup,Sheet,Gridlines-- | New Users to Excel | |||
![GS[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
