Hello, I have two column in the excel of the header like the following, and I will like to match the second row identical to first row by using the following formula in A3, then I would like to highlight those duplicated value in yellow (eg. C1, C2), I don’t know what should I type in format all value here this formula is true when I use conditional formatting, I have highlight the cell range from A1 to E2, and then for the formula should I type “=$A1=$A2”? What about other rows?
A. B. C D. E
1. NAME2012. AGE2023. PHONE GENDER. BIRTH2020
2. NAME2024. AGE2026. PHONE GENDER. BIRTH2023
3. NAME2024.