One way:

CF1: Formula is =ROW()<=700
Format1: <patterns/green

CF2: Formula is =ROW()<=1400
Format2: <patterns/yellow

CF3: Formula is =ROW()<=2100
Format3 <patterns/red

In article ,
weirdaljr
wrote:


I need to format a range of row by bow #. All I can find online is
formulas for odd or even rows. I'm new at this, sorry. But say if I
want Rows 1-700 Green, 701-1400 Yellow, and 1401 - 2100 Red. I thought
I would use 3 differant conditions in conditional formatting, but what
forumulas would I need to put in?