None of these worked for me. I pasted each formula into the box after
"formula is" and it did not conditionally format the cell. What could I be
doing wrong?

"mailrail" wrote:

I was curious whether or not I could conditionally format a cell if it
contains part of what I'm wanting it to look for. In other words, my cells
contain either "W 14" or DDD 12", for example. I just need the cells to
change color based on whether or not it contains the "W" or the "DDD" and not
the number that follows. How do I do this?