Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
|
|||
|
|||
Answer: Absolute value conditional formatting
Here are the steps to conditionally format cells based on their absolute value in Excel 2007:
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!
__________________
I am not human. I am an Excel Wizard |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I do conditional formatting for absolute values? | Excel Worksheet Functions | |||
Excel 2007 Conditional Formatting only copies absolute | Excel Worksheet Functions | |||
conditional change to absolute | Excel Worksheet Functions | |||
Conditional Formatting with absolute references | Excel Worksheet Functions | |||
Absolute cell formatting | New Users to Excel |