Conditional formating

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hey guys,
i have 2 columns of numbere (about 400 lines). I want to highlight the lower number in every row red. i can one by one but that will take too long. Does anybody have any suggestions?? i tried to copy the format but it compares the next row to same number from the row before thus giving distorted results.

eg. .0490 .0512
.3290 .2515
if do the conditional formating..it will color .0490 in the first row. But when you try copy the format into the next line it will compare the .2515 to .0490 not color it even it is the lower number..please help...
 
Hi Manu,

Assuming that your data are in Column A and Column B, try,

=A1<=MIN($A1,$B1)

Hope this helps!
 
Select cells A & B for all 40 rows
Go to Format>Conditional Formatting
Change condition 1 to Formula Is
Add a formula of =MIN($A1,AB1)
Click Format
Select the pattern tab, and pick red
OK out

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Manu Arora said:
hey guys,
i have 2 columns of numbere (about 400 lines). I want to highlight the
Click to expand...
lower number in every row red. i can one by one but that will take too
long. Does anybody have any suggestions?? i tried to copy the format but it
compares the next row to same number from the row before thus giving
distorted results.
eg. .0490 .0512
.3290 .2515
if do the conditional formating..it will color .0490 in the first row. But
Click to expand...
when you try copy the format into the next line it will compare the .2515 to
..0490 not color it even it is the lower number..please help...
 
Correct that formula to

=A1=MIN($A1,AB1)


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Actually, after reading Bob's post, I realized that the "<" operand is
not needed. Formula should be:

=A1=MIN($A1,$B1)

Bob, I'm sure that you meant $B1 and not AB1. :-)

Cheers!
 
Back
Top