Glad to send along the trial version of my "Shade Data Rows" Excel add-in.
Select the data and with a couple of clicks the selection or the entire
sheet is shaded "by value" in alternating colors of your choice.
Can also shade alternating rows or alternating groups of n rows.
Send an email to james.coneXXX at comcast.netXXX (remove the xxx).
Please include your real name and geographic location.
--
Jim Cone
Portland, Oregon USA



"Michael"

wrote in message
Thanks but I was hoping to do it automatically so the user wouldn't
have to copy down a formula. I suppose I could use an Insert Row
event to copy Col B.