Chris Hull
Chris Hull

Reputation: 127

Formatting row by row with conditional formatting in Excel

Let's say I have 2 columns that I'm comparing data in. If both cells match I want both cells to turn green. If they don't match I want them to turn yellow. Is there a formula that will allow me to check this for multiple records, or would this require looping in VBA? I can only seem to make this work 1 record at a time using conditional formatting. Thanks!

Edit: Adding results from provided answer

Upvotes: 4

Views: 1561

Answers (1)

Tim Williams
Tim Williams

Reputation: 166126

You can use conditional formatting, but you'll have to format each of the two columns separately.

Say your data is in A2:B100 (for simplicity)

Select the cells in columnA (A2:A100)
Select conditional Formatting >> New Rule >> Use a formula...
Enter the formula "=A3<>B3", choose a format and click OK

Repeat on column B.

Upvotes: 1

Related Questions