Absolute value conditional formatting

  • Thread starter Thread starter E
  • Start date Start date
E

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.
 
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.
 
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
 
Great, thank you both.

Bassman62 said:
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
 
Back
Top