conditional formatting

  • Thread starter Thread starter angela
  • Start date Start date
A

angela

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

Frank
 
it worked...you're a genius! thanks a million!
-----Original Message-----
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

Frank




.
Click to expand...
 
Back
Top