Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Absolute value conditional formatting

5,014 views
Skip to first unread message

E

unread,
Jun 26, 2009, 11:16:02 AM6/26/09
to

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

unread,
Jun 26, 2009, 11:46:43 AM6/26/09
to

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" <E...@discussions.microsoft.com> wrote in message
news:9FC03DC0-252C-4CDA...@microsoft.com...

RagDyeR

unread,
Jun 26, 2009, 11:40:05 AM6/26/09
to

Try this:

=ABS(A1)>1
--

HTH,

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


"E" <E...@discussions.microsoft.com> wrote in message
news:9FC03DC0-252C-4CDA...@microsoft.com...

E

unread,
Jun 26, 2009, 12:04:02 PM6/26/09
to

Great, thank you both.

Bassman62

unread,
Jun 26, 2009, 12:44:14 PM6/26/09
to

Your welcome. Thanks for the feedback.


"E" <E...@discussions.microsoft.com> wrote in message

news:A4658A90-889D-42CB...@microsoft.com...

0 new messages