Hey Ken,

Thanks for the reply. I found your response to be EXACTLY what I was looking
for.
Great info. Have a great rest of the weekend.

Thanks again

"Ken Wright" wrote:

Hi Jerry, my apologies, and sorry if it sounded like preaching, but it
really does come across as not nice when you see posts laid out like that,
and there just seem to have been a fair number of them lately throughout the
groups, so it tends to rub more than it should do - System's fault for
allowing it to happen like that, but hopefully that will change soon. Also,
I do not work for Microsoft, and nor do probably 99.999% of people that
frequent these groups, we are generally just interested users that enjoy
using a product and like to help others get the best out of it where we can.
Now asuming you then say but what about that MVP thingy then in case you are
curious here is an explanation as to what that is all about.

http://mvp.support.microsoft.com/

Don't be misled though, as there are some amazing individuals in these
groups that aren't necessarily tagged that way.

Anyway, back to your question :-) :-

Not quite sure exactly what you mean about printing the lowest, but i'll
take a stab. I'll assume you have 4 values in say A1:A4 and then in say A10
you want to have the smallest value appear such that whenever you print A10
you will get the lowest number in there. Simply put the following formula
in A10

=MIN(A1:A4)

As to highlighting the cell, select A1:A4 and do Format / Conditional
Formatting / Change 'cell value is' to 'formula is' and put in
=A1=MIN($A$1:$A$4)

Thne hit the format button, choose a colour perhaps from the patterns tab
and then hit OK. Now the cell(s) with the lowest value in will
automatically be coloured with whatever colour you chose from the list.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------
<snip