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
|