The formula is OK, though you can omit the outher pair of parentheses. You
need to remember, however, to put it under "Formula Is", rather than "Cell
Value Is". If in doubt, go back into CF and check that the formula is as
you intended it. Excel has a nasty habit of changing things, for example
changing the formula to a string if you forgot the initial = sign.
--
David Biddulph

"Carol" wrote in message
...
I am trying to set up conditional formatting so that an absolute value
greater than 3 will change the cell background color to red. I have
tried:
=(abs(f5))3 with f5 being the cell location.