Conditional formatting

S

SlipperyPete

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

Duke Carey

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

B. R.Ramachandran

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
 
S

SlipperyPete

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

SlipperyPete

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