Conditional Format Formula For Highest Value in Column B, highlighting Row A&B

[surkdidat]

Name	Score
Peter	53
Steve	26
Andy	71
James	44
Nigel	55

I am after a conditional formatting FORMULA please (aware there is an option to highlight the top 1) to highlight the highest score in Column B, but also highlight the name in Column A (So Andy, 71) in this example

Many thanks

 

[Joe4]

Follow these steps (for your example):

1. Select Range A2:B6
2. Go to Conditional Formatting and select the formula option
3. Enter the following formula:

=MAX($B$2:$B$6)=$B2

4. Chose your desired formatting
5. Click OK

Results:

 

[surkdidat]

Follow these steps (for your example):

1. Select Range A2:B6
2. Go to Conditional Formatting and select the formula option
3. Enter the following formula:

=MAX($B$2:$B$6)=$B2

4. Chose your desired formatting
5. Click OK

Results:
View attachment 98906

Thank you! Works a treat!

 

[Joe4]

You are welcome.