I'm having difficulty doing a comparison format.

Data appear as follows:
..........A B C D E F G
Row 1: 1 1 2 1 2 1 1
Row 2: 2 1 2 1 1 2 1

What I want to do is compare row 1 with row 2, and highlight BOTH
values if they are different.

ie. A1 = 1, A2 = 2 -- I want both these values to be formatted to
indicate they are different.
The desired end result here would be to have A1, A2, E1, E2, F1 and F2
formatted to stand out.

Suggestions?
Thanks!


--
SlipperyPete
------------------------------------------------------------------------
SlipperyPete's Profile: http://www.excelforum.com/member.php...o&userid=31220
View this thread: http://www.excelforum.com/showthread...hreadid=520644

You'll need to apply formatting to each row separately. Start in the first
row and set the formatting for Cell Value < A2 (assumes A1 is active when
you do this)

Repeat for row 2, but set the formatting for Cell value < A1 (assumes A2 is
active when you do this)



"SlipperyPete" wrote:


I'm having difficulty doing a comparison format.

Data appear as follows:
..........A B C D E F G
Row 1: 1 1 2 1 2 1 1
Row 2: 2 1 2 1 1 2 1

What I want to do is compare row 1 with row 2, and highlight BOTH
values if they are different.

ie. A1 = 1, A2 = 2 -- I want both these values to be formatted to
indicate they are different.
The desired end result here would be to have A1, A2, E1, E2, F1 and F2
formatted to stand out.

Suggestions?
Thanks!


--
SlipperyPete
------------------------------------------------------------------------
SlipperyPete's Profile: http://www.excelforum.com/member.php...o&userid=31220
View this thread: http://www.excelforum.com/showthread...hreadid=520644

Hi,

Select the entire area (i.e., A1:G2) -- "Format" -- "Conditional
Formatting" -- click on "Cell Values Is" and select "Formula is" -- enter
the formula =A$1<A$2 -- click on the "Format" button and format as you wish
-- "OK" -- "OK"

Regards,
B. R. Ramachandran

"SlipperyPete" wrote:


I'm having difficulty doing a comparison format.

Data appear as follows:
..........A B C D E F G
Row 1: 1 1 2 1 2 1 1
Row 2: 2 1 2 1 1 2 1

What I want to do is compare row 1 with row 2, and highlight BOTH
values if they are different.

ie. A1 = 1, A2 = 2 -- I want both these values to be formatted to
indicate they are different.
The desired end result here would be to have A1, A2, E1, E2, F1 and F2
formatted to stand out.

Suggestions?
Thanks!


--
SlipperyPete
------------------------------------------------------------------------
SlipperyPete's Profile: http://www.excelforum.com/member.php...o&userid=31220
View this thread: http://www.excelforum.com/showthread...hreadid=520644

There's no way to apply it to the entire sheet at once?

That is, I have data in row 1 and 2 that I want to compare; row 3 is
blank; row 4 and 5 I also want to compare.

Is there a way to format the whole sheet at once, or do I need to go
row by row?

Tnx for the help!


--
SlipperyPete
------------------------------------------------------------------------
SlipperyPete's Profile: http://www.excelforum.com/member.php...o&userid=31220
View this thread: http://www.excelforum.com/showthread...hreadid=520644

No further suggestions? There's no way to apply this to sets of rows or
the whole sheet at once?


--
SlipperyPete
------------------------------------------------------------------------
SlipperyPete's Profile: http://www.excelforum.com/member.php...o&userid=31220
View this thread: http://www.excelforum.com/showthread...hreadid=520644