This can be of tremendous importance. Interesting, this fails for me in 2016 version. 50%, and reduces hundreds of mouse clicks for you every day. But, if you want to check if multiple cells have the same value, this formula will not work. See screenshot: Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries. With Kutools for Excel’s Compare Cells utility, you can quickly find the same or different values between two cells. One way =AND(A1<"",A1=B1)--Regards, Peo Sjoblom "Peter Boardman"