All geek questions in one place

Line formatting with conditional formatting in Excel

Suppose I have 2 columns in which I compare data. If both cells match, I want both cells to turn green. If they do not match, I want them to turn yellow. Is there a formula that allows me to check this for multiple records, or does it require looping in VBA? I can only make this record one record at a time using conditional formatting. Thanks!

Change: Adding results from the provided answer

+4
source share
1 answer

You can use conditional formatting, but you will 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 in column B.

+1
source

Source: https://habr.com/ru/post/1379542/

More articles:


All Articles