Good morning,

I have a spreadsheet that calculates the incident rate for various work
sites - 17 in total. I would like the cell with the highest incident rate to
have its background change to red. I'm uncertain as to how I can have the
worksheet compare the 17 values and determine which is the highest. With
conditional formating I am able to set 3 conditions and not the 16 I would
need to solve my problem that way. Thanks in advance for any help.

Can't you use the MAX function in a Formula IS condition? If you want
a different colour for the second largest, then you can use the
LARGE( ... 2) function.

Hope this helps.

Pete

On May 14, 2:21*pm, REJesser
wrote:
Good morning,

I have a spreadsheet that calculates the incident rate for various work
sites - 17 in total. *I would like the cell with the highest incident rate to
have its background change to red. *I'm uncertain as to how I can have the
worksheet compare the 17 values and determine which is the highest. *With
conditional formating I am able to set 3 conditions and not the 16 I would
need to solve my problem that way. *Thanks in advance for any help.

Clearly I have done something incorrectly. I used the following as the
condition:

Formula Is =MAX($P$8:$P$25)

and then pasted it into cells P8 through P25. The result is all of the
cells changing color. I tried to outsmart it by using your second suggestion.

Formula Is =LARGE($P$8:$P$25,1)

I lost. What am I doing incorrectly? Thanks.

"Pete_UK" wrote:

Can't you use the MAX function in a Formula IS condition? If you want
a different colour for the second largest, then you can use the
LARGE( ... 2) function.

Hope this helps.

Pete

On May 14, 2:21 pm, REJesser
wrote:
Good morning,

I have a spreadsheet that calculates the incident rate for various work
sites - 17 in total. I would like the cell with the highest incident rate to
have its background change to red. I'm uncertain as to how I can have the
worksheet compare the 17 values and determine which is the highest. With
conditional formating I am able to set 3 conditions and not the 16 I would
need to solve my problem that way. Thanks in advance for any help.

Select P8:P25
With P8 the activecell, use this
Format|conditinal formatting
Formula is: p8=max($p$8:$p$25)

Same kind of thing with the second condition (if you wanted it):
formula is: p8=large($p$8:$p$25,2)



REJesser wrote:

Clearly I have done something incorrectly. I used the following as the
condition:

Formula Is =MAX($P$8:$P$25)

and then pasted it into cells P8 through P25. The result is all of the
cells changing color. I tried to outsmart it by using your second suggestion.

Formula Is =LARGE($P$8:$P$25,1)

I lost. What am I doing incorrectly? Thanks.

"Pete_UK" wrote:

Can't you use the MAX function in a Formula IS condition? If you want
a different colour for the second largest, then you can use the
LARGE( ... 2) function.

Hope this helps.

Pete

On May 14, 2:21 pm, REJesser
wrote:
Good morning,

I have a spreadsheet that calculates the incident rate for various work
sites - 17 in total. I would like the cell with the highest incident rate to
have its background change to red. I'm uncertain as to how I can have the
worksheet compare the 17 values and determine which is the highest. With
conditional formating I am able to set 3 conditions and not the 16 I would
need to solve my problem that way. Thanks in advance for any help.



--

Dave Peterson

Making progress; however, when the formula is saved as a condition, quotes
are placed around the whole darn thing.

"P8=MAX($P$8:$P$25)" instead of just P8=MAX($P$8:$P$25)

These quotes seem to render the formula useless. How can I keep the quotes
from appearing? Thanks.

"Dave Peterson" wrote:

Select P8:P25
With P8 the activecell, use this
Format|conditinal formatting
Formula is: p8=max($p$8:$p$25)

Same kind of thing with the second condition (if you wanted it):
formula is: p8=large($p$8:$p$25,2)



REJesser wrote:

Clearly I have done something incorrectly. I used the following as the
condition:

Formula Is =MAX($P$8:$P$25)

and then pasted it into cells P8 through P25. The result is all of the
cells changing color. I tried to outsmart it by using your second suggestion.

Formula Is =LARGE($P$8:$P$25,1)

I lost. What am I doing incorrectly? Thanks.

"Pete_UK" wrote:

Can't you use the MAX function in a Formula IS condition? If you want
a different colour for the second largest, then you can use the
LARGE( ... 2) function.

Hope this helps.

Pete

On May 14, 2:21 pm, REJesser
wrote:
Good morning,

I have a spreadsheet that calculates the incident rate for various work
sites - 17 in total. I would like the cell with the highest incident rate to
have its background change to red. I'm uncertain as to how I can have the
worksheet compare the 17 values and determine which is the highest. With
conditional formating I am able to set 3 conditions and not the 16 I would
need to solve my problem that way. Thanks in advance for any help.



--

Dave Peterson

What Dave gave you was a formula.
All formulas *start* with an equal sign.

Therefore, enter:

=p8=max($p$8:$p$25)


--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"REJesser" wrote in message
...
Making progress; however, when the formula is saved as a condition, quotes
are placed around the whole darn thing.

"P8=MAX($P$8:$P$25)" instead of just P8=MAX($P$8:$P$25)

These quotes seem to render the formula useless. How can I keep the quotes
from appearing? Thanks.

"Dave Peterson" wrote:

Select P8:P25
With P8 the activecell, use this
Format|conditinal formatting
Formula is: p8=max($p$8:$p$25)

Same kind of thing with the second condition (if you wanted it):
formula is: p8=large($p$8:$p$25,2)



REJesser wrote:

Clearly I have done something incorrectly. I used the following as the
condition:

Formula Is =MAX($P$8:$P$25)

and then pasted it into cells P8 through P25. The result is all of the
cells changing color. I tried to outsmart it by using your second
suggestion.

Formula Is =LARGE($P$8:$P$25,1)

I lost. What am I doing incorrectly? Thanks.

"Pete_UK" wrote:

Can't you use the MAX function in a Formula IS condition? If you want
a different colour for the second largest, then you can use the
LARGE( ... 2) function.

Hope this helps.

Pete

On May 14, 2:21 pm, REJesser
wrote:
Good morning,

I have a spreadsheet that calculates the incident rate for various
work
sites - 17 in total. I would like the cell with the highest
incident rate to
have its background change to red. I'm uncertain as to how I can
have the
worksheet compare the 17 values and determine which is the highest.
With
conditional formating I am able to set 3 conditions and not the 16 I
would
need to solve my problem that way. Thanks in advance for any help.



--

Dave Peterson

Oops.

Use:
=P8=MAX($P$8:$P$25)

Sorry about that.

REJesser wrote:

Making progress; however, when the formula is saved as a condition, quotes
are placed around the whole darn thing.

"P8=MAX($P$8:$P$25)" instead of just P8=MAX($P$8:$P$25)

These quotes seem to render the formula useless. How can I keep the quotes
from appearing? Thanks.

"Dave Peterson" wrote:

Select P8:P25
With P8 the activecell, use this
Format|conditinal formatting
Formula is: p8=max($p$8:$p$25)

Same kind of thing with the second condition (if you wanted it):
formula is: p8=large($p$8:$p$25,2)



REJesser wrote:

Clearly I have done something incorrectly. I used the following as the
condition:

Formula Is =MAX($P$8:$P$25)

and then pasted it into cells P8 through P25. The result is all of the
cells changing color. I tried to outsmart it by using your second suggestion.

Formula Is =LARGE($P$8:$P$25,1)

I lost. What am I doing incorrectly? Thanks.

"Pete_UK" wrote:

Can't you use the MAX function in a Formula IS condition? If you want
a different colour for the second largest, then you can use the
LARGE( ... 2) function.

Hope this helps.

Pete

On May 14, 2:21 pm, REJesser
wrote:
Good morning,

I have a spreadsheet that calculates the incident rate for various work
sites - 17 in total. I would like the cell with the highest incident rate to
have its background change to red. I'm uncertain as to how I can have the
worksheet compare the 17 values and determine which is the highest. With
conditional formating I am able to set 3 conditions and not the 16 I would
need to solve my problem that way. Thanks in advance for any help.



--

Dave Peterson


--

Dave Peterson

And there was much rejoicing! Thanks to all of you for your assistance.

"RagDyeR" wrote:

What Dave gave you was a formula.
All formulas *start* with an equal sign.

Therefore, enter:

=p8=max($p$8:$p$25)


--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"REJesser" wrote in message
...
Making progress; however, when the formula is saved as a condition, quotes
are placed around the whole darn thing.

"P8=MAX($P$8:$P$25)" instead of just P8=MAX($P$8:$P$25)

These quotes seem to render the formula useless. How can I keep the quotes
from appearing? Thanks.

"Dave Peterson" wrote:

Select P8:P25
With P8 the activecell, use this
Format|conditinal formatting
Formula is: p8=max($p$8:$p$25)

Same kind of thing with the second condition (if you wanted it):
formula is: p8=large($p$8:$p$25,2)



REJesser wrote:

Clearly I have done something incorrectly. I used the following as the
condition:

Formula Is =MAX($P$8:$P$25)

and then pasted it into cells P8 through P25. The result is all of the
cells changing color. I tried to outsmart it by using your second
suggestion.

Formula Is =LARGE($P$8:$P$25,1)

I lost. What am I doing incorrectly? Thanks.

"Pete_UK" wrote:

Can't you use the MAX function in a Formula IS condition? If you want
a different colour for the second largest, then you can use the
LARGE( ... 2) function.

Hope this helps.

Pete

On May 14, 2:21 pm, REJesser
wrote:
Good morning,

I have a spreadsheet that calculates the incident rate for various
work
sites - 17 in total. I would like the cell with the highest
incident rate to
have its background change to red. I'm uncertain as to how I can
have the
worksheet compare the 17 values and determine which is the highest.
With
conditional formating I am able to set 3 conditions and not the 16 I
would
need to solve my problem that way. Thanks in advance for any help.



--

Dave Peterson

We all appreciate the feed-back.
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"REJesser" wrote in message
...
And there was much rejoicing! Thanks to all of you for your assistance.

"RagDyeR" wrote:

What Dave gave you was a formula.
All formulas *start* with an equal sign.

Therefore, enter:

=p8=max($p$8:$p$25)


--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"REJesser" wrote in message
...
Making progress; however, when the formula is saved as a condition, quotes
are placed around the whole darn thing.

"P8=MAX($P$8:$P$25)" instead of just P8=MAX($P$8:$P$25)

These quotes seem to render the formula useless. How can I keep the
quotes
from appearing? Thanks.

"Dave Peterson" wrote:

Select P8:P25
With P8 the activecell, use this
Format|conditinal formatting
Formula is: p8=max($p$8:$p$25)

Same kind of thing with the second condition (if you wanted it):
formula is: p8=large($p$8:$p$25,2)



REJesser wrote:

Clearly I have done something incorrectly. I used the following as
the
condition:

Formula Is =MAX($P$8:$P$25)

and then pasted it into cells P8 through P25. The result is all of
the
cells changing color. I tried to outsmart it by using your second
suggestion.

Formula Is =LARGE($P$8:$P$25,1)

I lost. What am I doing incorrectly? Thanks.

"Pete_UK" wrote:

Can't you use the MAX function in a Formula IS condition? If you
want
a different colour for the second largest, then you can use the
LARGE( ... 2) function.

Hope this helps.

Pete

On May 14, 2:21 pm, REJesser
wrote:
Good morning,

I have a spreadsheet that calculates the incident rate for various
work
sites - 17 in total. I would like the cell with the highest
incident rate to
have its background change to red. I'm uncertain as to how I can
have the
worksheet compare the 17 values and determine which is the
highest.
With
conditional formating I am able to set 3 conditions and not the 16
I
would
need to solve my problem that way. Thanks in advance for any
help.



--

Dave Peterson