Sight Lines

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to automatically add a "sight line" across my spreadsheet, about
every 3rd or 4th row. This could be a line (border) or maybe a shaded row.
Is there an easy way to do this?
 
You can use Conditional Formatting for this:

If you have Excel 2003 or older:
Select your range of cells to apply the "sight lines" to
From the Format Menu, choose "Conditional Formatting"
Change "Cell Value Is" to "Formula Is"
Enter the formula: =MOD(ROW(),3)=0
Click the Format Button
Choose your format (fill color and/or borders)
Click OK

If you have Excel 2007:
Go to the "Styles" section of the Home Tab
Click on "Conditional Formatting"
Select "New Rule"
Select "Use a formula to determine which cells to format"
Enter the formula: =MOD(ROW(),3)=0
Click the Format Button
Choose your format
Click OK

Note: You can adjust the numbers 3 and 0 in the formula to change how many
rows are skipped, and which row the formatting starts on.

HTH,
Elkar
 
Thanks much! That does it!
--
bart972


Elkar said:
You can use Conditional Formatting for this:

If you have Excel 2003 or older:
Select your range of cells to apply the "sight lines" to
From the Format Menu, choose "Conditional Formatting"
Change "Cell Value Is" to "Formula Is"
Enter the formula: =MOD(ROW(),3)=0
Click the Format Button
Choose your format (fill color and/or borders)
Click OK

If you have Excel 2007:
Go to the "Styles" section of the Home Tab
Click on "Conditional Formatting"
Select "New Rule"
Select "Use a formula to determine which cells to format"
Enter the formula: =MOD(ROW(),3)=0
Click the Format Button
Choose your format
Click OK

Note: You can adjust the numbers 3 and 0 in the formula to change how many
rows are skipped, and which row the formatting starts on.

HTH,
Elkar
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word Dashed line formatting 0
Repeated shading of rows?? 8
Idiot Sighting 5
Shading 3
how do I shade alternating rows in spreadsheet 7
Big Black Cat sighting 9
Change highlight cell color 6
Remove a line 2

Back
Top