hello,

in column A, I have:
red
blue
green
black
white
yellow

i would like column B to copy these, however, "blue" and "black" should be changed to the word "dark"
whilst "white" and "yellow" is changed to "bright"

red and green should be as they are.

so column B will be:
red
dark
green
dark
bright
bright


thank you