Row Formatting

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

stiglo - 13 Sep 2007 18:36 GMT

Is it possible to format a row based on a text value compared from a cell in
that row to a cell in the row above it?

I review a report daily that is about 200 pages long, of which 80% of it is
duplicate information.

Reply to this Message

Duke Carey - 13 Sep 2007 19:00 GMT

Let's say you have data in cells A3:K1000, and the text values that you want
to compare are in column E

Start by selecting the SECOND row of data all the way to the last row. Be
sure that A4 is the active cell (press Ctrl-. [that's a period] until A4 is
the active cell). Now go to Fromatting>Conditional Formatting.

Choose "Formula is" and use this formula

=$k4<>$k3

Click on the format button and choose whatever format you want to
distinguish the rows. Ok your way back to the spreadsheet.

If you have to compare the data in more than one column, change the formula
like so

=AND($k4<>$k3,$L4<>$L3)

> Is it possible to format a row based on a text value compared from a cell in
> that row to a cell in the row above it?
>
> I review a report daily that is about 200 pages long, of which 80% of it is
> duplicate information.

Reply to this Message

stiglo - 13 Sep 2007 20:08 GMT

That is almost perfect! I should have specified how I wanted the rows
formatted...I would like to "Hide" those particular rows...Can't do that with
conditional formatting...or can you?

> Let's say you have data in cells A3:K1000, and the text values that you want
> to compare are in column E
[quoted text clipped - 20 lines]
> > I review a report daily that is about 200 pages long, of which 80% of it is
> > duplicate information.

Reply to this Message

Duke Carey - 13 Sep 2007 20:16 GMT

No - you can't hide them in that fashion. What you can do is put the formula

=$k4<>$k3

In an empty column adjacent to your data, then filter on FALSE. That will
hide the multiple rows

> That is almost perfect! I should have specified how I wanted the rows
> formatted...I would like to "Hide" those particular rows...Can't do that with
[quoted text clipped - 24 lines]
> > > I review a report daily that is about 200 pages long, of which 80% of it is
> > > duplicate information.

Reply to this Message

stiglo - 13 Sep 2007 23:44 GMT

Thanks brother!

> No - you can't hide them in that fashion. What you can do is put the formula
>
[quoted text clipped - 31 lines]
> > > > I review a report daily that is about 200 pages long, of which 80% of it is
> > > > duplicate information.

Reply to this Message