I think Conditional Formatting will do what you're asking for....

If the values are in A2:A20
and you want to flag any values that are NOT between 100 and 200,
inclusive...
try this:

Select A2:A20, with A2 as the active cell.

Then....from the Excel Main Menu:
<format<conditional formatting
Condition_1:
Formula is: =OR(A2<100,A2200)
Click the [format] button....set the color...Click [OK]
Click [OK]

Is that something you can work with?
Post back if you have more questions.
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)


"Rob Allmighty" <Rob wrote in message
...
I need to know if there is a way to have data that doesnt fall within a
certain range to come up a different color so I will know it is not within
range by looking at it and not have to look up to find out.