Excel help

OneADay

I have Excel 2007 and am trying to achieve the follow with rows of numbers.

If a number exists in previous row, highlight in a different colour.

Now I know of COUNTIF and conditional formatting but can't quite figure how to put the two together. Or is there a different way?

InsideInsurance

Given you are using the row above to highlight the row below and assuming the data is in A1->L200 then....

Highlight A2->L200. Click conditional formatting, New Rule, Use a Formula
and enter:

=MATCH(123456,$A1:$L1,0)>0

Where 123456 is the number you want it to look for

OneADay

Not quite working for me.
Its either highlighting nothing or a whole column or row gets highlighted.

I want formula lookup value to vary - so if I set it like this then it will change to look A2, A3 depending on each sell

=MATCH(A1,$A1:$L1,0)>0

But even using

=MATCH(1,$A1:$L1,0)>0

does not seem to be working at moment - using just 4 rows of data - columns A to L

InsideInsurance

If its cell by cell then its easier, as above in terms of area to select and conditional funding but the formula is

=A1=A2

OneADay

Something is not working then.
If I just look at result of MATCH(A1,$A1:$L4,0), its coming back with N/A.

InsideInsurance

No, its simply

=A1=A2

In the conditional formatting formula

The Match() was being used to highlight rows as I thought you want it so that if any cell in the row above had a set value. The function returns the position of the first match or an n/a if there is no match