Thread: Applying Max Conditonal Formatting to an entire row when condition
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
  
Posts: 15,768
Default Applying Max Conditonal Formatting to an entire row when condition
Try it like this...

Select the range of cells A1:D1
Goto 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?


Reply With QuoteReply With Quote