Question: conditional formatting if two values are the same?
Answer: Method A Conditional formatting rows or cells if two columns equal. ... In the New Formatting Rule dialog, select Use a formula to determine which cells to format from Select a Rule Type section, then type =$A2=$B2 into the text box under Format values where this formula is true.