I'm currently working in a Google sheet where I use the following formula to catch duplicate values with conditional formatting:
While this works on its own, I find that it does not account for duplicate values I do not want to be counted. In column O, I have values marking the row as "Canceled". So I want to have Google sheets only conditionally format cells if the following criteria are met:
- The value in column B has a duplicate
- Neither duplicate value has the word "canceled" in column O for that row.
This is the formula I tried, but it no longer formats duplicates:
I think what this has done has told the logic to not format duplicates unless there are no instances of "canceled" in column O.