Software

Ask something
Discussion Locked

how to mark cells containing specific

0 helpful
3 replies

by hunterzh

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

How to highlight cells containing specific characters?

In Excel 2000, how to conditional format cells containing specific characters, for example, "\"?
I want to select cells from one column, which has "\" inside.

3 replies

by dklippert

Go to Format>Conditional Formatting.
In the first box change to "Formula Is"
Type

=NOT(ISERROR(SEARCH("*\*",A1)))

Select Format
Click OK

This discussion is closed to new replies.