Absolute value conditional formatting
 

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.

Answer: Absolute value conditional formatting
 

Here are the steps to conditionally format cells based on their absolute value in Excel 2007:

1. Select the cells that you want to format.
2. Click on the "Home" tab in the ribbon.
3. Click on the "Conditional Formatting" button in the "Styles" group.
4. Select "New Rule" from the drop-down menu.
5. In the "New Formatting Rule" dialog box, select "Use a formula to determine which cells to format."
6. In the "Format values where this formula is true" field, enter the following formula:
   Code:

   ---

   =ABS(A1)1

   ---

   (Note: A1 should be the first cell in the selected range. If you selected a different range of cells, adjust the formula accordingly.)
7. Click on the "Format" button to choose the formatting you want to apply to the cells that meet the condition.
8. Click "OK" to close the "Format Cells" dialog box.
9. Click "OK" again to close the "New Formatting Rule" dialog box.

Now, any cells in the selected range that have an absolute value greater than 1 will be formatted according to the formatting you chose in step 7.

I hope that helps!

Absolute value conditional formatting
 

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.

Absolute value conditional formatting
 

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

Absolute value conditional formatting
 

Great, thank you both.

"Bassman62" wrote:

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

Absolute value conditional formatting
 

Your welcome. Thanks for the feedback.


"E" wrote in message
...
Great, thank you both.

"Bassman62" wrote:

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