Need to know Formula for Conditional Formatting Rows, by row #

W

weirdaljr

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?
 
J

JE McGimpsey

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
 
Top