Have a look at Format|Conditional Formatting..

Cell Value is .... Between

or ... Not Between

etc..