Please help with Conditional Formatting
 

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

Hi!

Try this:

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

Biff

-----Original Message-----
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

.

Try

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

--

HTH

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


"Wind54Surfer" wrote in message
...
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

Thanks a lot,

Emilio




"Biff" wrote:

Hi!

Try this:

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

Biff

-----Original Message-----
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

.