I thought I used to be able to highlight rows containing certain text,
but I can't figure it out now. Conditional formatting will only work
on individual cells, right?

I work a lot with filtered lists, and if there were some way to show
not only the filtered row but also the one above and maybe the one
below that would also achieve my objective, which is to have a forumula
in thefiltered row that uses data from the previous row, and then to
show them both together without any other rows.

Sorry for the newbie-like question, but sometimes I just draw a blank
on how to do something in Excel. I also have this need when working
with any kind of find, as in word or unix, to show some contex with the
search results, i.e. the row above and optionally below.


--
Spalding
------------------------------------------------------------------------
Spalding's Profile: http://www.excelforum.com/member.php...fo&userid=8634
View this thread: http://www.excelforum.com/showthread...hreadid=483484