View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default Conditional formatting based on max in range of other columns

1. Select the cell/Range.Column A.
2. From menu FormatConditional Formatting
3. For Condition1Select 'Formula Is' and enter the below formula
=COUNTIF(B1:R1,MAX(B:R))

4. Click Format ButtonPattern and select your color (say Red)
5. Hit OK

PS: IF the initial selection is not entire column A and say A2:A10; then the
formula would be =COUNTIF(B2:R2,MAX($B$2:$R$10))

If this post helps click Yes
---------------
Jacob Skaria


"Steve" wrote:

If I have a list oif names in the A column, and various #s in columns B thru
R, and the max of those #'s is in B20. Can I conditional format any A column
name that has the max # (14) in it's row. Basically I'd like to conditional
format the names Steve and Billy because they're the only ones that have a 14
in their row.

Thanks,

A B ..... Q R
Steve 13 14 11
Rick 13 7 10
Billy 12 14 9
Kurt 13 7 9
Dan 12 6 13

max 14