This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I am trying to use conditional formatting to see if there are duplicates in two sets of 2 separate (AA, AE, and AQ) columns. I had this working last year with this spreadsheet, but this year after I copied it, it is not working. I have attached two screen shots of the old and new spreadsheets, showing the formulas. I tried copying and pasting the formula that worked into the new copy of the spreadsheet. It gave me a message; see screenshot. Can anyone help me write a formula that will compare column AE with AQ for duplicates? I must also compare column AA with AQ for duplicates. I appreciate you time and expertise. I'm using Windows 11.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
must also compare column AA with AQ for duplicates.
?
what do you mean duplicates?
A value of cell in AA same as another value cell in AQ?
Can you share some data in text which can paste to Excel?
Rich, Thank you so much for your time and expertise. I ended up going with a more simple solution- I used the "duplicate" option when I created the formatting. It worked fine.
Again, thank you for your patient guidance.
Gwen K.
I managed to solve my problem. Thank you for your interest.