Absolute value conditional formatting

[E]

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.

 

[RagDyeR]

Try this:

=ABS(A1)>1
--

HTH,

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


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.

 

[Bassman62]

Select the cells you wish to format. In this example I selected A1:A5.
On the Home Tab, Conditional Formatting, New Rule, Use a formula...,
formula: =ABS(A1)>1
If you select multiple columns and want each row to format based on column A
then: =ABS($A1)>1
You can extend the range by adjusting it in the "Applies to" field in the CD
Rules Manager.

Best Regards,
Dave

 

[E]

Great, thank you both.

Select the cells you wish to format. In this example I selected A1:A5.
On the Home Tab, Conditional Formatting, New Rule, Use a formula...,
formula: =ABS(A1)>1
If you select multiple columns and want each row to format based on column A
then: =ABS($A1)>1
You can extend the range by adjusting it in the "Applies to" field in the CD
Rules Manager.

Best Regards,
Dave

 

[Bassman62]

Your welcome. Thanks for the feedback.

Great, thank you both.