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