• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

conditional formatting

dolphintabby

dolphintabby

Member
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.
 
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
 
You must log in or register to reply here.
Back
Top