S
Steve
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
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