I am not an Excel person, but I do have to use it a little for work. . Is there a way for me to format a column to be a highlighted color if another column of cells has a specific word entered into it? For example, I want any cell in column C to turn yellow if the word "high" is entered into any cell in column A.
Bookmarks