Highlight Top 3 Values Plus Row Using Conditional Formatting

[Renier]

I'd like to use conditional formatting to highlight not only the top three values in column D, but the entire row. Can someone help with a formula pls? It should look like this when done:

Thanks.

 

[Fluff]

Based on your image, select A2:D10 and use this formula
=$D2>=LARGE($D$2:$D$10,3)

 

[Renier]

Based on your image, select A2:D10 and use this formula
=$D2>=LARGE($D$2:$D$10,3)

Worked perfectly, thank you very much.

 

[Joe4]

Select the range A2:D10 and enter this Conditional Formatting formula:
=Rank($D2,$D$2:$D$10)<=3
and choose your green formatting option

EDIT: Too slow, I guess (didn't see Fluff's response), but this show's you a different way to do it.

 

[Renier]

Select the range A2:D10 and enter this Conditional Formatting formula:
=Rank($D2,$D$2:$D$10)<=3
and choose your green formatting option

EDIT: Too slow, I guess (didn't see Fluff's response), but this show's you a different way to do it.

Thanks

 

[Fluff]

Glad we could help & thanks for the feedback