Conditional Formatting based on text?
I think you can do conditional formatting, select the "between"
option, and put a in the first cell and z in the second. I just tested
it out and it seems to work even if the cell has multiple letters.
Once I type a number in it the format goes away.
Is that what you were looking for?
-Steven
On Feb 21, 4:10 pm, KarenH wrote:
Is it possible to implement conditional formatting based on text contained
in a cell? Example, user wants to be able to highlight all the cells in a
spreadsheet for a given entity (which will change all the time) so I'm
looking for something like "cell contains xyz" -- but as far as I can tell,
it works only with numeric values.
Am I trying to do something that is impossible?
Thanks in advance.
|