As a (junior) Excel user, I want to compare two columns and change the background colour for the cells which is not consistent.
1. Create New Rule:
you may select the B2, and click Conditional Formatting > New Rule:
Configure the formula and the format.
2. Apply the the rule:
You may right click the ‘+’and then drug, select the ‘Fill formatting Only’ when drop.
Or you can use Conditional Formatting > Manage Rules:
to change the “Applies to…” and then “Apply”
// Proudly powered by Apache, PHP, MySQL, WordPress, Bootstrap, etc,.