Hi!

The cell will look like this,1-8 (1)

I need Excel to recognize the 1

Which one?

=ISNUMBER(SEARCH("1-",A1))

=ISNUMBER(SEARCH("(1)",A1))

Biff


"Matt" wrote in message
...
Hi All

I am trying to use conditional formatting to change colors of cells for
scheduling purposes. There are a large amount (20) of criteria that could
make a cell one of three colors (representing work shifts). Each criteria
represents a work center and hours of work, ie 1-8, workstation 1 for 8
hours. The cell will look like this,1-8 (1), work center 1, 8 hours, on
shift 1. I need Excel to recognize the 1 and assign a corresponding
color.
If anyone could offer any assistance on the formula or formula setup, I
would
greatly appreciate it.