find the < within 3 rows
 

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

find the < within 3 rows
 

go to Conditional Formatting
insert the formula:

=MIN(A1:C1)

and select relevant formatting
then copy/paste special formats to all the 3 cells

find the < within 3 rows
 

Sorry it did not work for me. Again I need to see the smallest value highlited
--
smile


"Jarek Kujawa" wrote:

go to Conditional Formatting
insert the formula:

=MIN(A1:C1)

and select relevant formatting
then copy/paste special formats to all the 3 cells

find the < within 3 rows
 

Select the range from A1 to C1 with A1 as the active cell
do formatconditional formatting formula is

then use

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

select the format you want and click OK twice

--


Regards,


Peo Sjoblom

"israel" wrote in message
...
Sorry it did not work for me. Again I need to see the smallest value
highlited
--
smile


"Jarek Kujawa" wrote:

go to Conditional Formatting
insert the formula:

=MIN(A1:C1)

and select relevant formatting
then copy/paste special formats to all the 3 cells

find the < within 3 rows
 

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


"Peo Sjoblom" wrote:

Select the range from A1 to C1 with A1 as the active cell
do formatconditional formatting formula is

then use

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

select the format you want and click OK twice

--


Regards,


Peo Sjoblom

"israel" wrote in message
...
Sorry it did not work for me. Again I need to see the smallest value
highlited
--
smile


"Jarek Kujawa" wrote:

go to Conditional Formatting
insert the formula:

=MIN(A1:C1)

and select relevant formatting
then copy/paste special formats to all the 3 cells

find the < within 3 rows
 

Assume you have A1:C200, type that in the name box above column A's header
and press enter, then do formatconditional formatting and enter

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

do as previous



--


Regards,


Peo Sjoblom

"israel" wrote in message
...
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
--
smile


"Peo Sjoblom" wrote:

Select the range from A1 to C1 with A1 as the active cell
do formatconditional formatting formula is

then use

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

select the format you want and click OK twice

--


Regards,


Peo Sjoblom

"israel" wrote in message
...
Sorry it did not work for me. Again I need to see the smallest value
highlited
--
smile


"Jarek Kujawa" wrote:

go to Conditional Formatting
insert the formula:

=MIN(A1:C1)

and select relevant formatting
then copy/paste special formats to all the 3 cells

find the < within 3 rows
 

Bravo, Mr Peo Sjoblom
Thank you
--
smile


"Peo Sjoblom" wrote:

Assume you have A1:C200, type that in the name box above column A's header
and press enter, then do formatconditional formatting and enter

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

do as previous



--


Regards,


Peo Sjoblom

"israel" wrote in message
...
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
--
smile


"Peo Sjoblom" wrote:

Select the range from A1 to C1 with A1 as the active cell
do formatconditional formatting formula is

then use

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

select the format you want and click OK twice

--


Regards,


Peo Sjoblom

"israel" wrote in message
...
Sorry it did not work for me. Again I need to see the smallest value
highlited
--
smile


"Jarek Kujawa" wrote:

go to Conditional Formatting
insert the formula:

=MIN(A1:C1)

and select relevant formatting
then copy/paste special formats to all the 3 cells