Comparing 2 sets of test scores from 2 different databases

[KINNEY0201]

Good Morning,

I have two sets of test scores. Each set of test scores were taken from a different database.

I need assistance writing a formula that will compare the two sets of scores and flag any that do not match.

Example:

Student ID Database 1 Score Database 2 Score
1 520 520

2 560 560

3 580 565

In this example, the scores would be flagged in red for student 3 since the scores do not match in both databases.

I hope this makes sense.

As always, thanks in advance for your expertise and assistance. It is truly appreciated.

[Cutter]

You can select the full range of the 2 columns and use this as a Conditional Format formula:

=$B2<>$C2

assuming B2 is the top left cell of the range