Ok... I think I can figure that part out. But where do I put it and
how do i get it to run? Does it run automatically? Or will I have to
push the run macro button each time I want to check the cells? Which
would be ok for me but this is for several people and I need to make
it "idiot" proof.

I tried to do a sub where it made the active cell bold but I
appearntly didn't know enough about what I was doing to make it work
like it was supposed to. So I need a lil more help in this area.

I really know ever little at this point about excel programming.

What I really want this to do is just change the color of the cell
when someone enters in a value that's outside the limits. They
shouldn't have to push any buttons or click on anything to get it to
work. I know I'm asking a lot but if someone would just point me in
the right direction I can figure it out. At the current point I don't
have enough information to understand yet :)

Thanks for the help so far btw.... it has been very informative and I
have already learned a lot.

Dannic
http://www.orpgs.com

"Kathryn" wrote in message ...
Dannic, you could try something like this. I used "i" to
limit the number of rows I want looked at. If you are
looking at a large number of rows, you could increase to
50, 100, etc.

Option Explicit
Sub Review_WSvalues()
Dim i As Integer

Range("c5").Select 'enter 1st cell of the column w/data
i = 1
While i < 10
If ActiveCell.Value 0 Then
If ActiveCell.Value (ActiveCell.Offset(0, -2).Value
- ActiveCell.Offset(0, -2).Value _
* ActiveCell.Offset(0, -1).Value) And
ActiveCell.Value < (ActiveCell.Offset(0, -2).Value _
+ ActiveCell.Offset(0, -2).Value *
ActiveCell.Offset(0, -1).Value) Then
Selection.Interior.ColorIndex = 37
End If
End If
ActiveCell.Offset(1, 0).Select
i = i + 1
Wend
End Sub
-----Original Message-----
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
.