Row Formatting

[Guest]

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.

 

[Guest]

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)

 

[Guest]

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

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.

 

[Guest]

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
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

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.

 

[Guest]

Thanks brother!

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
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

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.