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!

Try it like this...

Assume the range of cells is A1:A3

Select the range of cells A1:A3
Goto the menu Format>Conditional 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" <(E-Mail Removed)> wrote in
message newsD309816-2489-4497-8A13-(E-Mail Removed)...
>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!

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 Format>Conditional 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" <(E-Mail Removed)> wrote in
> message newsD309816-2489-4497-8A13-(E-Mail Removed)...
> >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!
>
>
>

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

--
Biff
Microsoft Excel MVP


"SunshineinFt.Myers" <(E-Mail Removed)> wrote in
message news:45D24C60-E36A-4526-B3FA-(E-Mail Removed)...
> 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 Format>Conditional 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" <(E-Mail Removed)> wrote
>> in
>> message newsD309816-2489-4497-8A13-(E-Mail Removed)...
>> >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!
>>
>>
>>

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" <(E-Mail Removed)> wrote in
> message news:45D24C60-E36A-4526-B3FA-(E-Mail Removed)...
> > 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 Format>Conditional 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" <(E-Mail Removed)> wrote
> >> in
> >> message newsD309816-2489-4497-8A13-(E-Mail Removed)...
> >> >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!
> >>
> >>
> >>
>
>
>

See your other post

--
Biff
Microsoft Excel MVP


"SunshineinFt.Myers" <(E-Mail Removed)> wrote in
message news:B738FB6F-01AC-4AFF-A0EE-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote
>> in
>> message news:45D24C60-E36A-4526-B3FA-(E-Mail Removed)...
>> > 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 Format>Conditional 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" <(E-Mail Removed)>
>> >> wrote
>> >> in
>> >> message newsD309816-2489-4497-8A13-(E-Mail Removed)...
>> >> >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!
>> >>
>> >>
>> >>
>>
>>
>>