Are you comparing cells in the same row (e.g.) A1 with B1 or in a differentrow?If A1 and B1 are different which one do you want to colour?Could you do this better by using conditional formatting rather than a macro?