CODEWITHSUNDEEP
excelexcel-formulaconditional-formatting
soflo305
soflo305

Reputation: 15

Conditional formatting formula for exact match

I'm sorry if this has been answered in any form.. I was unable to find anything that I could apply to help my situation since my list is so long.

I have large spreadsheets (1000-3000 lines) and i'm using the following formula in conditional formatting to highlight my spreadsheet rows.

Example formula:

=OR(ISNUMBER(FIND("Accounting",$C1)),ISNUMBER(FIND("Retl Wor",$C1)),ISNUMBER(FIND("Finance",$C1)),ISNUMBER(FIND("FINANCE - ARC",$C1)),ISNUMBER(FIND("Audit",$C1)))

This formula is shortened (I have about 40-60 words in them. I have 3 formulas; One to highlight yellow, one to highlight green, one to highlight red). This formula is working decently but it also highlights cells containing the word "Accounting". So the word "Chem Accounting" is being highlighted, as well. I don't want this to happen.. I need my formula to highlight only EXACT matches. Thank you for any advice/help, I appreciate it.

Upvotes: 0

Views: 397

Answers (1)

extensionhelp
extensionhelp

Reputation: 574

Use a combination of exact matches and FINDs where needed.

=OR(C1="ACCOUNTING",ISNUMBER(FIND("Retl Wor",$C1)),etc...

Upvotes: 0

Related Questions