conditional format highlight name that has highest value points

[bluefeather8989]

in column C a list of names and in column D the final score for the person. I need a conditional format the name and score of the highs point (as seen in sample).

 

[SanjayGMusafir]

Check this and revert -

Book2
	A	B
1	Danny	4
2	Lisa	7
3	Trial	3
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1:B3	Expression	=$B1=MAX($B:$B)	text	NO

 

[bluefeather8989]

Check this and revert -

Book2
	A	B
1	Danny	4
2	Lisa	7
3	Trial	3
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1:B3	Expression	=$B1=MAX($B:$B)	text	NO

I'm sorry it was early in the morning when I wrote this. the column has more than 1 score set. need to set each one individually.

 

[SanjayGMusafir]

Simply modify the formula for ranges like below

=$D2=MAX($D2:$D3)