Trying to add conditional formatting to every other cell...GOING .
 

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

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

.

All of you have been great for offering your help...however, you won't
believe why I couldn't do this...I was not selecting/highlighting both cells
before painting!!! I was only selecting the cell where the condition was
given!

Something so simple took me ALL day to figure out & had everyone wondering
why it worked for them and not me!

Thanks again everyone...

"Debra Dalgleish" wrote:

Insert a blank row at the top of the list
Select the cells in column B, e.g. B2:B500
Choose FormatConditional Formatting
From the first dropdown, choose Formula Is
In the formula box, type: =AND(MOD(ROW(B2),2)=0,B2<B3)
Click the Format button, and choose a Pattern colour.
Click OK

Click the Add button
For Condition 2, select Formula Is
In the formula box, type: =AND(MOD(ROW(B2),2)=1,B2<B1)
Click the Format button, and choose a Pattern colour.
Click OK, click OK


trixiebme wrote:
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



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html