Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
conditional formatting
0 views
Skip to first unread message
angela
Feb 10, 2004, 3:48:13 PM2/10/04
to
i have a column with about 10 different values in each
cell, in the rows going across from each column are other
values related to the corresponding column cell. i need
each row to be conditionally formatted to identify if the
value is greater than the home column/cell, but
conditional formatting can only be used three times. i
don't know if there is any formula that can do the same
thing...apply formatting? so basically, on each row (Row 1)
i need to determine if the cells (B1-H1) are greater than
the value in the first cell (A1). but i need to do this
for about 10 rows. any ideas?????? i'm stumped...
cell, in the rows going across from each column are other
values related to the corresponding column cell. i need
each row to be conditionally formatted to identify if the
value is greater than the home column/cell, but
conditional formatting can only be used three times. i
don't know if there is any formula that can do the same
thing...apply formatting? so basically, on each row (Row 1)
i need to determine if the cells (B1-H1) are greater than
the value in the first cell (A1). but i need to do this
for about 10 rows. any ideas?????? i'm stumped...
Frank Kabel
Feb 10, 2004, 3:55:05 PM2/10/04
to
Hi Angela
try the following (I assume you test each row individually)
- select all your cells from B1 to Hx
- Goto 'Conditional format' and enter the following formula:
=B1>$A1
- choose your format for values >the first column
try the following (I assume you test each row individually)
- select all your cells from B1 to Hx
- Goto 'Conditional format' and enter the following formula:
=B1>$A1
- choose your format for values >the first column
Frank
angela
Feb 10, 2004, 4:38:24 PM2/10/04
to
it worked...you're a genius! thanks a million!
>.
>
0 new messages