Please help with Conditional Formatting

[Guest]

Hi all,

I am trying to get a cell to change color when:
D5 contains "/" in the form of for example:

CM/F/CM or C/C

I tried different variations of:

Formula Is------------------$D$5= "*/*"

but it does not work, any ideas?

Thanks for nay help,
Emilio

 

[Biff]

Hi!

Try this:

Formula Is: =ISNUMBER(SEARCH("/",A1))

Biff

 

[Bob Phillips]

Try

=ISNUMBER(FIND("/",$D$5))

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Guest]

Thanks a lot,

Emilio

Hi!

Try this:

Formula Is: =ISNUMBER(SEARCH("/",A1))

Biff