I need help with changing a cells value depending on what another cells value is. Basically, I want A1 to be blank, unless B1 contains the word "blue". If B1 contains the word blue, then I want A1 to display a certain word. Thank you in advance!
Solved by O. D. in 13 mins