Selecting rows in a spreadsheet

G

Gareth Edmondson

Hi,

I have a list of coursework marks in an Excel sheet - covering 150 rows.
They have been sorted from highest mark to lowest mark.

I wonder if anyone has a Macro that I could use to colour every 5th pupil
row - highlighting the work that has to be sent off for moderation?

Many thanks, your help is much appreciated,

Gareth Edmondson
 
B

Bob Phillips

Gareth,

Using Conditional Formatting.

Select all of your target rows
Go to Format>Conditional Formatting
Change Condition1 to Formula Is
Input the formula =MOD(ROW(),5)=0
Click the format button
Select the Pattern tab
Choose a colour (Light Green is good)
Exit out

The beauty of this solution is that it works correctly even if you insert
rows


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
G

Gareth Edmondson

Bob Phillips said:
Gareth,

Using Conditional Formatting.

Select all of your target rows
Go to Format>Conditional Formatting
Change Condition1 to Formula Is
Input the formula =MOD(ROW(),5)=0
Click the format button
Select the Pattern tab
Choose a colour (Light Green is good)
Exit out

The beauty of this solution is that it works correctly even if you insert
rows
Click to expand...

Hi Bob,

That is marvelous - not just the solution (which I will try in a moment),
but the speed at which you replied.

Thanks and best wishes,

Gareth Edmondson
 
Top