Applying Conditional Formatting to a Max number in range
 

I highlight the cells: Ex 1, 5, and 10 go conditional formatting and I am not
sure how to specify that I want the number 10 which is the max number in the
range to turn green or any color. I type =(max) A1:A3. Choose my color and
apply but it never changes. Help this is for work!

Applying Conditional Formatting to a Max number in range
 

Try it like this...

Assume the range of cells is A1:A3

Select the range of cells A1:A3
Goto the menu FormatConditional Formatting
Select the Formula Is option
Enter this formula in the box on the right:
=AND(A1<"",A1=MAX(A$1:A$3))
Click the Format button
Select the desired style(s)
OK out

--
Biff
Microsoft Excel MVP


"SunshineinFt.Myers" wrote in
message ...
I highlight the cells: Ex 1, 5, and 10 go conditional formatting and I am
not
sure how to specify that I want the number 10 which is the max number in
the
range to turn green or any color. I type =(max) A1:A3. Choose my color and
apply but it never changes. Help this is for work!

Applying Conditional Formatting to a Max number in range
 

Thank you very much. I have another if you feel like answering. How about
doing the same thing only highlighting the entire row of the one cell that
has the Max or Min Number?

"T. Valko" wrote:

Try it like this...

Assume the range of cells is A1:A3

Select the range of cells A1:A3
Goto the menu FormatConditional Formatting
Select the Formula Is option
Enter this formula in the box on the right:
=AND(A1<"",A1=MAX(A$1:A$3))
Click the Format button
Select the desired style(s)
OK out

--
Biff
Microsoft Excel MVP


"SunshineinFt.Myers" wrote in
message ...
I highlight the cells: Ex 1, 5, and 10 go conditional formatting and I am
not
sure how to specify that I want the number 10 which is the max number in
the
range to turn green or any color. I type =(max) A1:A3. Choose my color and
apply but it never changes. Help this is for work!

Applying Conditional Formatting to a Max number in range
 

Based on the same condition of the max value in A1:A3?

--
Biff
Microsoft Excel MVP


"SunshineinFt.Myers" wrote in
message ...
Thank you very much. I have another if you feel like answering. How about
doing the same thing only highlighting the entire row of the one cell that
has the Max or Min Number?

"T. Valko" wrote:

Try it like this...

Assume the range of cells is A1:A3

Select the range of cells A1:A3
Goto the menu FormatConditional Formatting
Select the Formula Is option
Enter this formula in the box on the right:
=AND(A1<"",A1=MAX(A$1:A$3))
Click the Format button
Select the desired style(s)
OK out

--
Biff
Microsoft Excel MVP


"SunshineinFt.Myers" wrote
in
message ...
I highlight the cells: Ex 1, 5, and 10 go conditional formatting and I
am
not
sure how to specify that I want the number 10 which is the max number
in
the
range to turn green or any color. I type =(max) A1:A3. Choose my color
and
apply but it never changes. Help this is for work!

Applying Conditional Formatting to a Max number in range
 

Say that I am actually going across. Ex: A1, B1, C1 and finally the cell
which had the number 10 is the cell with the max value. However, I do have
larger numbers in the other cells B1, C1, ect...but I don't want their max.
I only want to count my last column D1=10 and make highlight the entire row.
"T. Valko" wrote:

Based on the same condition of the max value in A1:A3?

--
Biff
Microsoft Excel MVP


"SunshineinFt.Myers" wrote in
message ...
Thank you very much. I have another if you feel like answering. How about
doing the same thing only highlighting the entire row of the one cell that
has the Max or Min Number?

"T. Valko" wrote:

Try it like this...

Assume the range of cells is A1:A3

Select the range of cells A1:A3
Goto the menu FormatConditional Formatting
Select the Formula Is option
Enter this formula in the box on the right:
=AND(A1<"",A1=MAX(A$1:A$3))
Click the Format button
Select the desired style(s)
OK out

--
Biff
Microsoft Excel MVP


"SunshineinFt.Myers" wrote
in
message ...
I highlight the cells: Ex 1, 5, and 10 go conditional formatting and I
am
not
sure how to specify that I want the number 10 which is the max number
in
the
range to turn green or any color. I type =(max) A1:A3. Choose my color
and
apply but it never changes. Help this is for work!

Applying Conditional Formatting to a Max number in range
 

See your other post

--
Biff
Microsoft Excel MVP


"SunshineinFt.Myers" wrote in
message ...
Say that I am actually going across. Ex: A1, B1, C1 and finally the cell
which had the number 10 is the cell with the max value. However, I do have
larger numbers in the other cells B1, C1, ect...but I don't want their
max.
I only want to count my last column D1=10 and make highlight the entire
row.
"T. Valko" wrote:

Based on the same condition of the max value in A1:A3?

--
Biff
Microsoft Excel MVP


"SunshineinFt.Myers" wrote
in
message ...
Thank you very much. I have another if you feel like answering. How
about
doing the same thing only highlighting the entire row of the one cell
that
has the Max or Min Number?

"T. Valko" wrote:

Try it like this...

Assume the range of cells is A1:A3

Select the range of cells A1:A3
Goto the menu FormatConditional Formatting
Select the Formula Is option
Enter this formula in the box on the right:
=AND(A1<"",A1=MAX(A$1:A$3))
Click the Format button
Select the desired style(s)
OK out

--
Biff
Microsoft Excel MVP


"SunshineinFt.Myers"
wrote
in
message ...
I highlight the cells: Ex 1, 5, and 10 go conditional formatting and
I
am
not
sure how to specify that I want the number 10 which is the max
number
in
the
range to turn green or any color. I type =(max) A1:A3. Choose my
color
and
apply but it never changes. Help this is for work!