While this does work it makes it difficult when there are 200 lines of
this to do. Is there a programmatic way of doing this to make it
easier to do? I would hate to do this cell by cell.

I also need to remove some text from those cells and take just the
Number values. For example:

1 2 3

190mv +/-2.5% 189.5

The conditional works but it is a real pain when it comes to 100 or so
lines that I would have to do for each template. I have about 300
templates to apply this to so it would take me a very long time to do.
And they are not all the same. I need a vb script to accomplish what
I am looking for. Least till someone can show me another way of doing
it without a script.

Dannic
Http://www.orpgs.com

"Bernie Deitrick" wrote in message ...
Dannic,

No programming needed.

With the nominal value in A1, the percentage (entered as a percentage)
in B1, use Format | Conditional formatting... on cell C1, selecting
"Formula Is" with the formula

=OR(C1A1*(1+B1),C1<A1*(1-B1))

Set your formatting pattern to the color of your choice

--
HTH,
Bernie


"Dannic" wrote in message
om...
I have a "template" of sorts. Basicly it has several columns. One
column has the nominal value. The next has a percentage value and
the
third is where the data taken is inserted.

What I would like to do is Take the first value. Find the upper and
lower limits per the second value. Compare those limits to the
third
value and if it is out of the range of the limits change the color
of
the cell or circle the cell.

I'm not all that familiar with Excel programming and any help would
be
appreciated.

Thanks

Dannic
Http://www.orpgs.com