| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 ... 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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 ... 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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 ... 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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 ... 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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 ... 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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Applying conditional formatting to dynamic range | Excel Discussion (Misc queries) | |||
| applying conditional formatting to emtpy cells in a spreadsheet | Excel Discussion (Misc queries) | |||
| Applying multiple distinct conditional formatting rules | Excel Discussion (Misc queries) | |||
| Applying Conditional Formatting to Multiple Worksheets - Excel 200 | Excel Discussion (Misc queries) | |||
| Applying Conditional Formatting to Muliple Worksheets in Excel 200 | Excel Discussion (Misc queries) | |||
Linear Mode
