My original question was posted a few minutes ago (scroll down to see) & I
got the answer below but it didn't work....I'm about to SCREAM!!!!

Can someone PLEASE help???
__________________________________________________ ____________

Hi Jason,

I tried what you said but it is being stubborn & continuing to format the
wrong cells! Any other ideas I can try???

Much Appreciated!

__________________________________________________ _____

Using B$1 locks the row. Change it to B1.

HTH
Jason
Atlanta, GA

-----Original Message-----
Desparately in need of help!!!

What I am trying to do is find the conditional
formatting that is going to
highlight the "Not equal to" cells.

In other words, below I have sample cell rows to the
left (1,2,3,...), a
column "A" and then I have two sets of matching #'s, one
below another.

I did a conditional formatting (from cell B2) that
said "Cell Values is"
"Not equal to" "=B$1"...I set it to highlight/shade when
one of the two cells
is not equal to the other.

It works great for the 1st 2 rows...however when I do a
paint formatting
from B2 down to the rest of the row, it formats the
wrong cells & every other
cell highlights...In other words...B3 not equal to B2,
B5 not equal to
B4....and so on!!!

PLEASE...I'm desperate.....can someone help!!!

A
1 83543520
2 83543520
3 09341720
4 109341720
5 7503362001
6 7503362001
7 0501652001
8 0501652001
9 94485620
10 94485620
11 22122520
12 22122520




Expand AllCollapse All