Applying Conditional Formatting to a Max number in range

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!
 
T

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
 
S

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?
 
S

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top