Select the entire sheet (with A1 active)
Then click Format Conditional Formatting
For Condition 1,
Formula is: =MOD(ROW(),7)=0
Format: light green fill OK out
The above will shade rows 7, 14, 21, etc
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Andy" wrote:
I want to create simple planner/calendar:

(a) Dates on the left
(b) One line for each day.
(c) The rest of the line going across the page for my text.

I would like to shade in every seventh row.

Can I do this shading automatically with Excel 2003?