If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
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 news 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! |
#3
|
|||
|
|||
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 news 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! |
#4
|
|||
|
|||
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 news 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! |
#5
|
|||
|
|||
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 news 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! |
#6
|
|||
|
|||
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 news 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! |
Thread Tools | |
Display Modes | |
|
|