Compare Column and highlight difference

You can use Conditional Formatting with two rules

Conditional Formatting

• Highlight applicable range >> $B$9:$F$116
• Home Tab >> Styles >> Conditional Formatting >> New Rule
• Select a Rule Type: Use a formula to determine which cells to format
• Edit the Rule Description: Format values where this formula is true: =B9<>I9
• Format… [Number, Font, Border, Fill] Select Fill >> Red
• OK >> OK

• Highlight applicable range >> $I$9:$M$116
• Home Tab >> Styles >> Conditional Formatting >> New Rule
• Select a Rule Type: Use a formula to determine which cells to format
• Edit the Rule Description: Format values where this formula is true: =I9<>B9
• Format… [Number, Font, Border, Fill] Select Fill >> Red
• OK >> OK