SFtoto
asked on
Excel 2010 compare two columns with multiple conditions
Hi Experts,
I would like to compare the two columns and highlighed the row if the specific condition is met like below:
Comparison 1:
- compare the strings in column A and B whether strings in the columns are capitalized or not. E.g.,
Column A Column B
SMITH smith
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.
Comparison 2:
- compare column A and B and if column A contains specific strings and column B has specific set of strings, highlight the row.
E.g.,
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
Thanks!
I would like to compare the two columns and highlighed the row if the specific condition is met like below:
Comparison 1:
- compare the strings in column A and B whether strings in the columns are capitalized or not. E.g.,
Column A Column B
SMITH smith
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.
Comparison 2:
- compare column A and B and if column A contains specific strings and column B has specific set of strings, highlight the row.
E.g.,
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
Thanks!
ASKER
I want to highlight only if one is capitalized and the other isn't.
Thanks!
Thanks!
Sorry, this got lost in my inbox.... are you still requiring assistance?
ASKER
Yes. It would be great if someone can show me how to do it.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks! This worked!!
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
Do want to highlight only if one is capitalized and the other isn't, or do you want to highlight as long as there is capitilization in either or both columns?