conditional formatting

[dolphintabby]

I need to highlight cells in one column when two cells in separate columns match in Excel 2003. I tried doing a conditional formatting formula is: =match($A1,$B1,0) while in the cell I want highlighted when that condition is true. & Excel gives me an error saying not enough arguements.

 

[Luke M]

not sure about having enough arguements, but the output of the MATCH function is either a number (which I suppose does count as TRUE) or #N/A (bad!)


Thinking on a simpler nature, why not just do:

=$A1=$B1