Let's first consider a table with different names in different columns. Then to highlight values without using a formula, you must follow the steps below: Choose columns A and B. Click on the find and select drop-down in the home tab. Then select the go-to special option. You must select row difference under it and click OK.