I have a conditional format set up with an IF statement, and it works fine. But I have realized that I need to add an additional criteria.
Column W contains either an x or is a blank cell
Column X contains a unique code to each entry consisting of both letters and numbers
=IF($X4="","",(ISBLANK($W4)))
The formula I currently have is designed to turn the cell (in Column W) red if there is a code in Column X, but not an x in Column W. Now what I have determined is that eventually all cells will receive a unique code in Column X, but I do not want Column W to be highlighted in red if the code contains the code of "_ETE_". Now that would be those 5 characters all togather like that. I am sure this is something very simple I am overlooking, but I am just not sure how to approach it. Thanks in advance for all your time and help!