Conditional Formating
 

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

click format and select red font, click OK twice

Can I copy or expand this to include al the cells down to A25,B25,C25

Conditional Formating
 

Yes, if the parameters are set as A$1, C$1 instead of $A$1, $C$1...


--
dminkov
------------------------------------------------------------------------
dminkov's Profile: http://www.excelforum.com/member.php...o&userid=17757
View this thread: http://www.excelforum.com/showthread...hreadid=492094

Conditional Formating
 

Fill down after changing to =A1=MIN($A1:$C1) so that row references are
relative instead of absolute.
Ken Johnson

Conditional Formating
 

This worked like a charm, Thanks

"Ken Johnson" wrote:

Fill down after changing to =A1=MIN($A1:$C1) so that row references are
relative instead of absolute.
Ken Johnson

Conditional Formating
 

i Think it should be $A1:$C1

"dminkov" wrote:


Yes, if the parameters are set as A$1, C$1 instead of $A$1, $C$1...


--
dminkov
------------------------------------------------------------------------
dminkov's Profile: http://www.excelforum.com/member.php...o&userid=17757
View this thread: http://www.excelforum.com/showthread...hreadid=492094