Applying Conditional Formatting to a Max number in range

[SunshineinFt.Myers]

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!

 

[T. Valko]

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

 

[SunshineinFt.Myers]

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]

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

 

[SunshineinFt.Myers]

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]

See your other post