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?