Forum Discussion
Is there a way to add text to a cell based off the fill or no fill of another cell, not using macros
Hello, I was hoping (see example below) to have Column B which has some cell filled with color to auto fill in Column C with relative text, (in this case the word "get") based off of color or no fill...
Not without macro's or office script. But if you can tell us the rule what makes a cell in column B have yellow or blue, you can use a simple formula in column C to change the displayed text