find the < within 3 rows

  • Thread starter Thread starter israel
  • Start date Start date
I

israel

How do I find < value out of multiple cell and highlight it
(A 1 - 1000 B1 - 900 c1 - 1700) what would be the formula to
highlight B1
 
go to Conditional Formatting
insert the formula:

=MIN(A1:C1)

and select relevant formatting
then copy/paste special formats to all the 3 cells
 
Select the range from A1 to C1 with A1 as the active cell
do format>conditional formatting formula is

then use

=A1=MIN($A$1:$C$1)

select the format you want and click OK twice

--


Regards,


Peo Sjoblom
 
Beautiful, it worked nice. Now can you help me with the rest.
I have 200 rows, how do I apply at one for the entire worksheet of 200 rows
 
Assume you have A1:C200, type that in the name box above column A's header
and press enter, then do format>conditional formatting and enter

=AND(ISNUMBER(A1),A1=MIN($A1:$C1))

do as previous



--


Regards,


Peo Sjoblom
 
Bravo, Mr Peo Sjoblom
Thank you
--
smile


Peo Sjoblom said:
Assume you have A1:C200, type that in the name box above column A's header
and press enter, then do format>conditional formatting and enter

=AND(ISNUMBER(A1),A1=MIN($A1:$C1))

do as previous



--


Regards,


Peo Sjoblom
Click to expand...
 
Back
Top