Conditional Formatting

[pcrowley]

I am using the following statement in conditional formatting to highlight cells that contain the character #.

=ISNUMBER(SEARCH("#",A2))

I also need to highlight cells that contain a quotation symbol ". When I replace the # with a " in the formula I get an error. How can I search for a ", and can I combine the search for the # and " in a single formula?

Thanks for the help

 

[Momentman]

Maybe =ISNUMBER(SEARCH("""",A2))

 

[pcrowley]

Perfect, thank you so much.