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)
UJA-QA (STiR created)