for a example in column E at cell E10 to E 30 I want the smallest
number I enter in each of those cells to be red.

If 3 cells are "0" all 3 should be red if one cell is "2" and all
other cells are more than 2 I want that "2" cell to show up as red
font.

To sum it up in cells E10 to E30 I want the lowest numbers to be red
if there are more than one of the lowest all should be red

Thanks
Ron

On Dec 5, 4:42*pm, Ron Rosenfeld <r...@nospam.net> wrote:
> On Sun, 5 Dec 2010 13:47:01 -0800 (PST), e_a_g_l_e_p_i
>
> <eagl...@hotmail.com> wrote:
> >for a example in column E at cell E10 to E 30 I want the smallest
> >number I enter in each of those cells to be red.
>
> >If 3 cells are "0" all 3 should be red if one cell is "2" and all
> >other cells are more than 2 I want that "2" cell to show up as red
> >font.
>
> >To sum it up in cells E10 to E30 I want the lowest numbers to be red
> >if there are more than one of the lowest all should be red
>
> >Thanks
> >Ron
>
> Take a look at Conditional Formatting
>
> Post back with your Excel Version if you can't figure out how to use
> it.

I have 2010, I don't know Excel at all so just telling me what feature
won't help me although I appreciate the help I need step by step
directions... Sorry

There are step by step directions in Excel help on Conditional Formatting.

No better time to learn how to scour the Help files.

If you can't or won't it seems a good time to turn the Excel tasks over to
someone else.


Gord Dibben MS Excel MVP

On Sun, 5 Dec 2010 14:46:22 -0800 (PST), e_a_g_l_e_p_i <(E-Mail Removed)>
wrote:

>On Dec 5, 4:42*pm, Ron Rosenfeld <r...@nospam.net> wrote:
>> On Sun, 5 Dec 2010 13:47:01 -0800 (PST), e_a_g_l_e_p_i
>>
>> <eagl...@hotmail.com> wrote:
>> >for a example in column E at cell E10 to E 30 I want the smallest
>> >number I enter in each of those cells to be red.
>>
>> >If 3 cells are "0" all 3 should be red if one cell is "2" and all
>> >other cells are more than 2 I want that "2" cell to show up as red
>> >font.
>>
>> >To sum it up in cells E10 to E30 I want the lowest numbers to be red
>> >if there are more than one of the lowest all should be red
>>
>> >Thanks
>> >Ron
>>
>> Take a look at Conditional Formatting
>>
>> Post back with your Excel Version if you can't figure out how to use
>> it.
>
>I have 2010, I don't know Excel at all so just telling me what feature
>won't help me although I appreciate the help I need step by step
>directions... Sorry

On Dec 5, 5:58*pm, Gord Dibben <phnor...@shaw.ca> wrote:
> There are step by step directions in Excel help on Conditional Formatting..
>
> No better time to learn how to scour the Help files.
>
> If you can't or won't it seems a *good time to turn the Excel tasks over to
> someone else.
>
> Gord Dibben * * MS Excel MVP
>
> On Sun, 5 Dec 2010 14:46:22 -0800 (PST), e_a_g_l_e_p_i <eagl...@hotmail.com>
> wrote:
>
>
>
> >On Dec 5, 4:42 pm, Ron Rosenfeld <r...@nospam.net> wrote:
> >> On Sun, 5 Dec 2010 13:47:01 -0800 (PST), e_a_g_l_e_p_i
>
> >> <eagl...@hotmail.com> wrote:
> >> >for a example in column E at cell E10 to E 30 I want the smallest
> >> >number I enter in each of those cells to be red.
>
> >> >If 3 cells are "0" all 3 should be red if one cell is "2" and all
> >> >other cells are more than 2 I want that "2" cell to show up as red
> >> >font.
>
> >> >To sum it up in cells E10 to E30 I want the lowest numbers to be red
> >> >if there are more than one of the lowest all should be red
>
> >> >Thanks
> >> >Ron
>
> >> Take a look at Conditional Formatting
>
> >> Post back with your Excel Version if you can't figure out how to use
> >> it.
>
> >I have 2010, I don't know Excel at all so just telling me what feature
> >won't help me although I appreciate the help I need step by step
> >directions... *Sorry- Hide quoted text -
>
> - Show quoted text -

If you don't want to help then don't answer the post, get a hobby and
stop spending your life being an hass - the h to people in
newsgroups

Hi
This formula will do what you want.
=A1=IF(MIN($A$1:$A$14)=A1,A1,"") Assuming your data starts at A1
You'll need to adjust the range.
As for instruction with conditional formating, I don't have XL2010, i'm using XL
2003
HTH
John



"e_a_g_l_e_p_i" <(E-Mail Removed)> wrote in message
news:f1abd810-829e-48f5-9133-(E-Mail Removed)...
On Dec 5, 5:58 pm, Gord Dibben <phnor...@shaw.ca> wrote:
> There are step by step directions in Excel help on Conditional Formatting.
>
> No better time to learn how to scour the Help files.
>
> If you can't or won't it seems a good time to turn the Excel tasks over to
> someone else.
>
> Gord Dibben MS Excel MVP
>
> On Sun, 5 Dec 2010 14:46:22 -0800 (PST), e_a_g_l_e_p_i <eagl...@hotmail.com>
> wrote:
>
>
>
> >On Dec 5, 4:42 pm, Ron Rosenfeld <r...@nospam.net> wrote:
> >> On Sun, 5 Dec 2010 13:47:01 -0800 (PST), e_a_g_l_e_p_i
>
> >> <eagl...@hotmail.com> wrote:
> >> >for a example in column E at cell E10 to E 30 I want the smallest
> >> >number I enter in each of those cells to be red.
>
> >> >If 3 cells are "0" all 3 should be red if one cell is "2" and all
> >> >other cells are more than 2 I want that "2" cell to show up as red
> >> >font.
>
> >> >To sum it up in cells E10 to E30 I want the lowest numbers to be red
> >> >if there are more than one of the lowest all should be red
>
> >> >Thanks
> >> >Ron
>
> >> Take a look at Conditional Formatting
>
> >> Post back with your Excel Version if you can't figure out how to use
> >> it.
>
> >I have 2010, I don't know Excel at all so just telling me what feature
> >won't help me although I appreciate the help I need step by step
> >directions... Sorry- Hide quoted text -
>
> - Show quoted text -

If you don't want to help then don't answer the post, get a hobby and
stop spending your life being an hass - the h to people in
newsgroups

You obviously also don't want to learn how to fish.


Gord

On Sun, 5 Dec 2010 16:13:10 -0800 (PST), e_a_g_l_e_p_i <(E-Mail Removed)>
wrote:

>If you don't want to help then don't answer the post, get a hobby and
>stop spending your life being an hass - the h to people in
>newsgroups

Hi Gord
Hope you will excuse me, I didn't mean to offend you, you may have had good
reason to right what you did, but I felt that the formula needed was not that
easy to get help with.
Excel help is ok to show you how to use CF but they only use very basic formula.
Best regards
John

"Gord Dibben" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> You obviously also don't want to learn how to fish.
>
>
> Gord
>
> On Sun, 5 Dec 2010 16:13:10 -0800 (PST), e_a_g_l_e_p_i <(E-Mail Removed)>
> wrote:
>
>>If you don't want to help then don't answer the post, get a hobby and
>>stop spending your life being an hass - the h to people in
>>newsgroups

I realise that OP would not have come up with your formula but I felt that no
effort had been made by OP to follow Ron's original suggestion of checking help
on CF

>I have 2010, I don't know Excel at all so just telling me what feature
>won't help me although I appreciate the help I need step by step
>directions... Sorry

Not a word about having looked at help or tried to figure out CF rules.

I would have responded much differently if I had seen evidence that attempts
were made but the task was too complex.

Perhaps OP did go through help but failed to mention that to Ron.

I apologize to OP if that's the case.

Otherwise, I remain unrepentant.


Gord

On Mon, 6 Dec 2010 13:06:53 -0500, "Cimjet" <(E-Mail Removed)> wrote:

>Hi Gord
>Hope you will excuse me, I didn't mean to offend you, you may have had good
>reason to right what you did, but I felt that the formula needed was not that
>easy to get help with.
>Excel help is ok to show you how to use CF but they only use very basic formula.
>Best regards
>John
>
>"Gord Dibben" <(E-Mail Removed)> wrote in message
>news:(E-Mail Removed)...
>> You obviously also don't want to learn how to fish.
>>
>>
>> Gord
>>
>> On Sun, 5 Dec 2010 16:13:10 -0800 (PST), e_a_g_l_e_p_i <(E-Mail Removed)>
>> wrote:
>>
>>>If you don't want to help then don't answer the post, get a hobby and
>>>stop spending your life being an hass - the h to people in
>>>newsgroups

Hi Gord
>I would have responded much differently if I had seen evidence that attempts
>were made but the task was too complex.

I know that, I was surprise to see your reply but did not pretend to know the
whole story.
I thought maybe a "Senior Moments" Ha,Ha , "a joke from last year if you
remember."
I've learned a lot from You and Ron in the last few years," I miss the old
newsgroup ".
Anyway the OP will have to read up on CF 2010 because I don't have it.
You Guys are the Guru of XL and I enjoy learning new stuff.
All the best to you
John

"Gord Deben" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I realise that OP would not have come up with your formula but I felt that no
> effort had been made by OP to follow Ron's original suggestion of checking
> help
> on CF
>
>>I have 2010, I don't know Excel at all so just telling me what feature
>>won't help me although I appreciate the help I need step by step
>>directions... Sorry
>
> Not a word about having looked at help or tried to figure out CF rules.
>
> I would have responded much differently if I had seen evidence that attempts
> were made but the task was too complex.
>
> Perhaps OP did go through help but failed to mention that to Ron.
>
> I apologize to OP if that's the case.
>
> Otherwise, I remain unrepentant.
>
>
> Gord
>
> On Mon, 6 Dec 2010 13:06:53 -0500, "Cimjet" <(E-Mail Removed)> wrote:
>
>>Hi Gord
>>Hope you will excuse me, I didn't mean to offend you, you may have had good
>>reason to right what you did, but I felt that the formula needed was not that
>>easy to get help with.
>>Excel help is ok to show you how to use CF but they only use very basic
>>formula.
>>Best regards
>>John
>>
>>"Gord Dibben" <(E-Mail Removed)> wrote in message
>>news:(E-Mail Removed)...
>>> You obviously also don't want to learn how to fish.
>>>
>>>
>>> Gord
>>>
>>> On Sun, 5 Dec 2010 16:13:10 -0800 (PST), e_a_g_l_e_p_i <(E-Mail Removed)>
>>> wrote:
>>>
>>>>If you don't want to help then don't answer the post, get a hobby and
>>>>stop spending your life being an hass - the h to people in
>>>>newsgroups

I do remember the thread from last year.

Don't discount your first impressions<g>

Getting older can also be used as an excuse for just being a curmudgeon.

Why should Harlan get all the press?


Gord

On Mon, 6 Dec 2010 14:32:20 -0500, "Cimjet" <(E-Mail Removed)> wrote:

>Hi Gord
>>I would have responded much differently if I had seen evidence that attempts
>>were made but the task was too complex.
>
>I know that, I was surprise to see your reply but did not pretend to know the
>whole story.
>I thought maybe a "Senior Moments" Ha,Ha , "a joke from last year if you
>remember."
>I've learned a lot from You and Ron in the last few years," I miss the old
>newsgroup ".
>Anyway the OP will have to read up on CF 2010 because I don't have it.
>You Guys are the Guru of XL and I enjoy learning new stuff.
>All the best to you
>John
>
>"Gord Deben" <(E-Mail Removed)> wrote in message
>news:(E-Mail Removed)...
>>I realise that OP would not have come up with your formula but I felt that no
>> effort had been made by OP to follow Ron's original suggestion of checking
>> help
>> on CF
>>
>>>I have 2010, I don't know Excel at all so just telling me what feature
>>>won't help me although I appreciate the help I need step by step
>>>directions... Sorry
>>
>> Not a word about having looked at help or tried to figure out CF rules.
>>
>> I would have responded much differently if I had seen evidence that attempts
>> were made but the task was too complex.
>>
>> Perhaps OP did go through help but failed to mention that to Ron.
>>
>> I apologize to OP if that's the case.
>>
>> Otherwise, I remain unrepentant.
>>
>>
>> Gord
>>
>> On Mon, 6 Dec 2010 13:06:53 -0500, "Cimjet" <(E-Mail Removed)> wrote:
>>
>>>Hi Gord
>>>Hope you will excuse me, I didn't mean to offend you, you may have had good
>>>reason to right what you did, but I felt that the formula needed was not that
>>>easy to get help with.
>>>Excel help is ok to show you how to use CF but they only use very basic
>>>formula.
>>>Best regards
>>>John
>>>
>>>"Gord Dibben" <(E-Mail Removed)> wrote in message
>>>news:(E-Mail Removed)...
>>>> You obviously also don't want to learn how to fish.
>>>>
>>>>
>>>> Gord
>>>>
>>>> On Sun, 5 Dec 2010 16:13:10 -0800 (PST), e_a_g_l_e_p_i <(E-Mail Removed)>
>>>> wrote:
>>>>
>>>>>If you don't want to help then don't answer the post, get a hobby and
>>>>>stop spending your life being an hass - the h to people in
>>>>>newsgroups