|
| 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
February 24th, 2009, 02:23 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Applying Max Conditonal Formatting to an entire row when condition
I want to change the entire row color when one cell is the max out of the
range. Ex: A1, B1, C1, with the the Max being in cell D1? 
|
|
#2
February 24th, 2009, 02:29 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Applying Max Conditonal Formatting to an entire row when condition
Try it like this...
Select the range of cells A1  1Goto the menu FormatConditional Formatting Select the Formula Is option Enter this formula in the box on the right: =AND(A1"",A1=MAX($A1:$D1)) Click the Format button Select the desired style(s) OK out -- Biff Microsoft Excel MVP "SunshineinFt.Myers" wrote in message ... I want to change the entire row color when one cell is the max out of the range. Ex: A1, B1, C1, with the the Max being in cell D1?
|
|
#3
February 24th, 2009, 05:56 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Applying Max Conditonal Formatting to an entire row when condition
Hi,
Try not to post the same question more than once (a day?). See your other post for another solution. -- If this helps, please click the Yes button Cheers, Shane Devenshire "SunshineinFt.Myers" wrote: I want to change the entire row color when one cell is the max out of the range. Ex: A1, B1, C1, with the the Max being in cell D1?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
