View Single Post
  #2   Report Post  
Biff
 
Posts: n/a
Default

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

.