I have text that will update my Excel spread sheet I never know how long the row will go because it is dependent on the date span.

How do I get the row to get a shaded quality to basically loop until there is no date or text in the cell?