| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to know Formula for Conditional Formatting Rows, by row #
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match then lookup | Excel Worksheet Functions | |||
| Changing a Formula in Conditional Formatting | Excel Worksheet Functions | |||
| Conditional formatting...cont. from 9/25 | Excel Discussion (Misc queries) | |||
| retrieve cell formatting with IF(HLOOKUP) formula | Excel Worksheet Functions | |||
| conditional formatting with formula | Excel Worksheet Functions | |||
Hybrid Mode
