How do I make the smallest number in a column red ( No VBA Please )

[e_a_g_l_e_p_i]

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

 

[Ron Rosenfeld]

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.

 

[e_a_g_l_e_p_i]

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

 

[Gord Dibben]

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

 

[e_a_g_l_e_p_i]

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




- 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

 

[Ron Rosenfeld]

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

I don't have 2010, but there should be an option on the ribbon for
Conditional Formatting. If you click "new rule" you should see a
dialog box. If the options you see are not helpful, there is a little
question mark in the upper right corner of the dialog box. Click on
that and you should see a HELPful explanation of what you can do.

Or you can select HELP from the main menu, and type "Conditional
Formatting" into the search box.

 

[Cimjet]

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

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




- 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

 

[Gord Dibben]

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


Gord

 

[Cimjet]

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]

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

 

[Cimjet]

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 Dibben]

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

 

[DCG-jaeson]

Hi Eagle,

=IF($E10=MIN($E$10:$E$30),TRUE,FALSE) ~> then choose the formats you
want to activate once meet the condition

Put this in your conditional formatting bar in cell E10 then COPY then
PASTE SPECIAL (Formats) up to cell E30. This one work in Excel2000 and
Excel2003. Hope will work on 2010.

I Prefer to learn how to catch a Fish! LOL!

~jaeson

 

[Aaron]

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

This works in Excel2007, with the ribbon. I do not know how much
different XL2010 is, but hopefully it is enough like XL2007 that this
gets the job done.

Select the affected column or range.

On the Home Ribbon click:
Conditional Formatting > Top/Bottom Rules > More Rules...
In the More Rules dialog:
In the top section (Select a Rule Type)
Select 'Format only top or bottom ranked values'
In the bottom section (Edit the Rule Description)
Select 'Bottom' from the dropdown box
Put a '1' in the unlabeled large box
Leave the checkbox by the '% of the selected range' unchecked
Click the 'Format...' button
In the Format Cells dialog
Click the 'Font' tab
In the 'Color...' dropdown box
Choose you font color; red in the case you posted
Click 'OK'
Click 'OK'