Link to home
Create AccountLog in
Avatar of Andreamary
Andreamary

asked on

Conditional formatting based on another column not containing a specific word (Excel)

I would like to implement the following in my Excel spreadsheet:

If Column A does not contain the text string 'internal', then Column B cell changes to green.

The Column A dropdown menu is as follows:
EDX-QA (STiR created)
NC-EQV
NC-FQV
NC-Internal
EDO
NC-NQV
GA QA
UJA-QA (STiR created)

Thanks!
Andrea
ASKER CERTIFIED SOLUTION
Avatar of Shums Faruk
Shums Faruk
Flag of India image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Andreamary
Andreamary

ASKER

Thanks to you both for your timely solutions! And thanks, Shums, for the taking the extra step of providing a VBA option.

Cheers,
Andrea
You're Welcome Andrea! We're glad that we're able to help you