Applying Conditional Formatting to a Max number in range

  • Thread starter Thread starter SunshineinFt.Myers
  • Start date Start date
S

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!
 
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
 
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?
 
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.
 
Back
Top