We help IT Professionals succeed at work.

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

151 Views
Last Modified: 2018-02-02
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
Comment
Watch Question

Managing Director/Excel VBA Developer
CERTIFIED EXPERT
Distinguished Expert 2018
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
Subodh Tiwari (Neeraj)Excel & VBA Expert
CERTIFIED EXPERT
Most Valuable Expert 2018
Awarded 2015
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
ShumsManaging Director/Excel VBA Developer
CERTIFIED EXPERT
Distinguished Expert 2018
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION

Author

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

Cheers,
Andrea
ShumsManaging Director/Excel VBA Developer
CERTIFIED EXPERT
Distinguished Expert 2018

Commented:
You're Welcome Andrea! We're glad that we're able to help you