Odd Conditional Formatting
So are you telling us that
=OR(ISNUMBER(FIND("W",A1)),ISNUMBER(FIND("DDD",A1) )) didn't give you the
conditional format for cells that contained W or DDD? Are you sure that you
specified an appropriate format in the CF?
If you paste that formula into a separate cell does it give a TRUE or FALSE?
Are you sure that you've got the formula that you think you have in CF? It
does have a tendency to throw in unwanted quote marks or to convert from
relative to absolute addressing.
Are you sure that the formula refers to the appropriate cell?
--
David Biddulph
"mailrail" wrote in message
...
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?
|