Filter by relative criteria

[Eileen]

Is there an easy way that I can fill out those rows that
meet certain criteria? For example, I have coloumn A
(Min),column B (Max)and the results are in column C, I
need to filter C4 (A4<C4<B4) and C8 (A8<C8<B8)....

Thanks

 

[Debra Dalgleish]

You can use an Advanced Filter. There are some instructions here:

http://www.contextures.com/xladvfilter01.html

Your criteria area will have a blank cell for a heading, and the
following formula in the cell below (assuming the data starts in row 4):

=AND(A4<C4,C4<B4)