Note: If both ranges you selected contain same headers, please check the My data has headers option.ģ. (6) Check the Select entire rows option as you need.
(5) In the Processing of results section, check the Fill backcolor option, and specify a fill color from below drop down list. (4)In the Find section, check the Same Values option (3) In the Based on section, check the Each row option (2) In the According to box, select the column you will apply conditional formatting based on from another worksheet or workbook ( Tip: If you can’t select the column from another opening workbook, you can type the range address directly such as 'Sheet1'!$A$1:$A$10. (1) In the Find Values in box, select the column in the current worksheet you will apply conditional formatting to