Formula To Show Which Cell Has The Highest Rate

[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!

 

[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

 

[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

 

[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

 

[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

 

[Kassie]

Which version of Excel do you use?

--
HTH

Kassie

Replace xxx with hotmail

 

[it''''''''sh hardy]

2007... Sorry for delay!

Which version of Excel do you use?

--
HTH

Kassie

Replace xxx with hotmail

 

[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

 

[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?

 

[Kassie]

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

--
HTH

Kassie

Replace xxx with hotmail