I would like to compare the two columns and highlighed the row if the specific condition is met like below:
- compare the strings in column A and B whether strings in the columns are capitalized or not. E.g.,
Column A Column B
Note: I would like to compare purely the strings if it's capitalized or not. I'm not comparing if the strings matches or not.
- compare column A and B and if column A contains specific strings and column B has specific set of strings, highlight the row.
If the column A contains the string, "Open" and column B contains either "In Queue" or "In Test", or "In Progress", then, highlight the row