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.

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

Who is Participating?
NBVCConnect With a Mentor Commented:
Assuming columns A and B, then select those columns:

Go to Home|Conditional Formatting|New Rule, then select:  use a formula to determine which cells to format

Then enter formula:


where A1 and B1 are top most cells.

click Format and choose colour.

click ok, then click New rule and repeat as above with formula:

=AND($A1="Open",OR($B1="In Queue",$B1="In Test",$B1="Progress"))

click Format and choose colour.

Click Ok.

Now in the rules list, make sure that last rule is at the top, and check the box that says Stop if True.

Let me know how it works.... and sorry again for losing track of your thread.
I am confused about 1st condition.

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?
SFtotoAuthor Commented:
I want to highlight only if one is capitalized and the other isn't.

Train for your Pen Testing Engineer Certification

Enroll today in this bundle of courses to gain experience in the logistics of pen testing, Linux fundamentals, vulnerability assessments, detecting live systems, and more! This series, valued at $3,000, is free for Premium members, Team Accounts, and Qualified Experts.

Sorry, this got lost in my inbox....  are you still requiring assistance?
SFtotoAuthor Commented:
Yes. It would be great if someone can show me how to do it.
SFtotoAuthor Commented:
Thanks! This worked!!
Martin LissOlder than dirtCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.