Direct link to Chip's version:

http://www.cpearson.com/excel/banding.htm



wrote:

-----Original Message-----
Try this on Chip Pearsons site, it will give you all you
need!

http://www.cpearson.com/excel.htm

You will find a section on colour formatting here.

Simon


---
Message posted from http://www.ExcelForum.com/

.


Simon,

Thanks for your reply. I couldn't actually find what
I wanted on the site you pointed me to (I'm sure it was
there but I am probably too impatient/jaded to weed it out
(been working too hard recently!)) but did find useful
help at:
http://j-walk.com/ss/excel/usertips/tip043.htm

For the benefit of anyone else who wants to do something
similar, a solution is:

With Range(???).SpecialCells(xlCellTypeVisible)
.FormatConditions.Delete
.FormatConditions.Add Type:=xlExpression, Formula1:= _
"=MOD(ROW(),2)=0"
.FormatConditions(1).Interior.ColorIndex = ???
End With

Regards,
Rosemary

--

Dave Peterson