Try this:

=ABS(A1)1
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


"E" wrote in message
...
Please can you help me with a simple question! I want to conditionally
format
cells whose absolute value is greater than 1, ie, negative numbers <-1, and
positive numbers 1.
I use Office 2007.

Many thanks.