View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sam Sam is offline
external usenet poster
 
Posts: 3
Default Inserting blank rows after ranges

Hi,
Hopefully someone can help.

I have a spreadsheet that contains employee ages in column D.

Anyone older than 21 but younger than 30 should be in one group and
have a blank row inserted before the next group starts. Which would
be older than 30 but younger than 36. And so on....I would also like
to color these blank rows yellow.

e.g.
Name plan location
Age
23
25
Insert Row
31
33
35
Insert Row

Can anyone help?
Thanks