vk7
Member
I am seeking assistance with applying conditional formatting to Row 2 of my spreadsheet. My goal is to compare values between Row 2 and Row 3 on a column-by-column basis. Specifically, I want to highlight any column in Row 2 where the corresponding values in Row 3 do not match.
For example:
Compare A2 with A3
Compare B2 with B3
Continue this comparison for all columns in Row 2 (A to BE)
I believe the EXACT function can be used to achieve this comparison. I attempted to test this by entering the formula =EXACT(A2, A3) in Row 4 for verification purposes. However, I encountered difficulties setting up the conditional formatting to highlight the relevant columns in Row 2 based on this comparison.
I would greatly appreciate any guidance on how to properly set up the conditional formatting rules to achieve this desired result.
For example:
Compare A2 with A3
Compare B2 with B3
Continue this comparison for all columns in Row 2 (A to BE)
I believe the EXACT function can be used to achieve this comparison. I attempted to test this by entering the formula =EXACT(A2, A3) in Row 4 for verification purposes. However, I encountered difficulties setting up the conditional formatting to highlight the relevant columns in Row 2 based on this comparison.
I would greatly appreciate any guidance on how to properly set up the conditional formatting rules to achieve this desired result.