Formula To Show Which Cell Has The Highest Rate

I

it''sh hardy

I work for a retail company and am trying to get the formula to show which
location has the highest rate. For instance - Brandon has 25 sales, Tampa has
30, and Clearwater has 50. This formula would automatically determine which
store has the highest and show up in RED saying BIGDOG!

Any help is better than what I have lol!

Thanks!
 
K

Kassie

Not knowing how many regions you want, I base my answer on three. Let's say
these are in A1:B3. In C1, enter =IF(B1=MAX($B$1:$B$3),"BIGDOG","")
Now, conditionally format range C1:C3, cell value equal to BIGDOG, format
font as Red
--
HTH

Kassie

Replace xxx with hotmail
 
I

it''''''''sh hardy

Kassie -

I tried this and it didn't work =( here's what cells I'm using and I want
the cell with the HIGHEST amount of sales to say bigdog

F4 through F10

Thanks, Mike
 
K

Kassie

I must apologise! Ileft out the bit about copying the formula down!
=IF(F4=MAX($F$4:$F$10),"BIGDOG","") in G4. Now copy down to G10, then do
the CF thing

--
HTH

Kassie

Replace xxx with hotmail
 
I

it''''''''sh hardy

Ok that worked!!! thank you!!! But when I do the CF it doesn't show up red,
and the number thats largest doesn't either? I'm sorry I'm such a pain!
lol... Also, do you know how to have a particular cell reference back to a
spreadsheet saved to a website?

Thanks
 
K

Kassie

On your Home tab, just right of centre, click on Conditional Formatting, then
on Highlight Cells Rules, Text that Contains. Enter BIGDOG! in the inputbox.
Click on the down arrow next to "with", and select Red Text.

--
HTH

Kassie

Replace xxx with hotmail
 
I

it''''''''sh hardy

Thanks Kassie - Also, I'm tring to format the cells to do the big dog thing
still and i can only get so many cells? I'm using F3-F9, G3-G9,H3-H9, and
I3-I9 i get through the first two, then 3 cells into H it stops working?
 
K

Kassie

Send me your file, os that I can see what you're doing

--
HTH

Kassie

Replace xxx with hotmail
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Is there an Excel formula to show the highest letter in a row? 8
Which CPU has the highest clock rate? 1
Is there an Excel formula to show the highest letter in a row? 1
How do I create the formula for this calculation? 1
How to copy and paste conditional formatting for the cell next to 4
formula to change font colour depending on which cell it has used 1
How to Show Records with No Data.......... 1
how to split the cell which has the date formula (with day) 3

Top