how do I do conditional formatting for absolute values?

C

Carol

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.
 
M

Mike H

Carol

Formula is
=ABS($F$5)>3

works for me and this can go in F5 or any other cell

Mike
 
D

David Biddulph

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting Query 1
Changing cell colors from a function command 3
Excel conditional formatting with Weeknum 4
Conditional Formatting Not Working As Intended 3
Conditional formating 1
Excel 2003 Conditional Formatting w/ 3 Conditions and a value = to 2
Conditional Formatting Driving Me Crazy 1
Using icon sets with relative references 0

Top