Copying conditional formatting...HELP PLEASE!!!!

[trixiebme]

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

 

[Ken Wright]

Answered in your original post

 

[Don Cameron]

trixiebme
I have just tried out what you described as being required and it works
perfectly for me. ( I was already aware of the need to get rid of the $
before the row number to allow a format paint to be copied)
You note that it does not work for you and you get every other row
highlighted.
I get rows 4,3,5,7,9 and 11 highlighted (which is every other line + line 4)

I suspect you are having a problem with deciding what question you want
answered.
What you are getting is the first of repeated values shaded the rest being
plain
You have (in your own terms) stated
B1 contains the first data item
If data B2 is not equal to data B1 then colour B2
If data B3 is not equal to data B2 then colour B3
If data B4 is not equal to data B3 then colour B4
If data B5 is not equal to data B4 then colour B5
If data B6 is not equal to data B5 then colour B6
If data B7 is not equal to data B6 then colour B7
If data B8 is not equal to data B7 then colour B8
If data B9 is not equal to data B8 then colour B9
If data B10 is not equal to data B9 then colour B10
If data B11 is not equal to data B10 then colour B11
Note that cell B1 will never have CF as it is not compared with anything.
To achieve this colouring enter the following CF in B2
'Cell Value is" not equal to =$B1
<then pick your shade/colour> if true
Cell B2 should remain uncoloured as B1=B2
Highlight Cell B2 <Format Paint> Highlight B3 to B12
You will find 3,4,5,7,9,11 have taken the shading which agrees with what was
asked for

I hope this clarifies the problem for you.
doncam65

 

[trixiebme]

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