S
Spalding
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 wor
on individual cells, right?
I work a lot with filtered lists, and if there were some way to sho
not only the filtered row but also the one above and maybe the on
below that would also achieve my objective, which is to have a forumul
in thefiltered row that uses data from the previous row, and then t
show them both together without any other rows.
Sorry for the newbie-like question, but sometimes I just draw a blan
on how to do something in Excel. I also have this need when workin
with any kind of find, as in word or unix, to show some contex with th
search results, i.e. the row above and optionally below
but I can't figure it out now. Conditional formatting will only wor
on individual cells, right?
I work a lot with filtered lists, and if there were some way to sho
not only the filtered row but also the one above and maybe the on
below that would also achieve my objective, which is to have a forumul
in thefiltered row that uses data from the previous row, and then t
show them both together without any other rows.
Sorry for the newbie-like question, but sometimes I just draw a blan
on how to do something in Excel. I also have this need when workin
with any kind of find, as in word or unix, to show some contex with th
search results, i.e. the row above and optionally below