Conditional Formatting - highlight a cell containing a specific character within text

[PaulKMc]

Hi All

I have an excel spread sheet & I wish to highlight any cell that contains any of the following characters with in a string of text.
/ \ : * " < > ? |

Eg. a cell in the spread sheet containing the text "Is this a Question?" would be highlighted.

I have tried to use - 'Format only cells that contain' > Specific Text > Containing > for each of the characters and this does not work.
When I do this any cell containing any text is highlighted.

Any ideas where I am going wrong?

In addition there is formatting on any cell > 60 characters which turns the cell red and this works fine.
What would happen if (when I get the problem above resolved), a cell is > than 60 characters & contains a character listed above?
Does 1 formatting take precedent over another?
(Not critical to know the answer to the additional question, just curious - as long as it is highlighted one colour or another then no problem.)

Any suggestions gratefully accepted.

Paul

[Pete_UK]

You should use a formula to determine the condition, rather than "Containing". Post an example file so we can see how your data is arranged.

Pete

[PaulKMc]

Thanks Pete - please find the attachment.
It is spreadsheet that builds a folder structure from Excel.
Top level folder column A, sub folder B etc.

Folders cannot be created if the name contains the characters listed above.

[L-Drr]

If column A contains the text, fill column B with =ISNUMBER((FIND("/";A1))
The result is TRUE of FALSE, which you can use for conditional formatting