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!