hmm doesnt seem to do the right comparison.
It does highlight cells, but not like the code specifies.
It looks like the hightlight are totaly random.

Any other ideas?
Im all out :(


Btw != is the same as NOT()


"Roger Govier" skrev:

Hi Chris

Mark the range A1:B7000
FormatConditional Formattinguse dropdown for Formula Is =A1=B1
Choose Format required

Note that in the formula pane it is essential to enter the starting =

--
Regards

Roger Govier


"ChrisP" wrote in message
...
sry

what I mean is that I want to perform the check on every row, like
this

If A1!=B1 change the color
If A2!=B2 change the color
etc
etc

"ChrisP" skrev:

Hi.

I have a spreadsheet with about 7000 rows.
To make this readable I would like to add some conditional formating
but I
just cant seem to get it right.


example If A!=B change the cellcolor of A to red

A B
1 1 1
2 3 5
3 2 2
4 4 1


Anyone got a clue?

Thanks alot!