I'm wanting to set up conditional formatting that looks at a range of
interger values.

For example I want to mark the following ranges in yellow:

-1499 to -200 and +200 to +1499

And these ranges in red:

<=-1500 and =+1500

My problem is can I just do this in the conditional formatting section or
will I actually need to write it as a Macro?

Thanks!

--
Teri Albert