Formatting Cells included in SUMPRODUCT

[MVolkert]

I am using the following formula to find the total of the 6 largest values in a range of cells...

=SUMPRODUCT(LARGE(B45:B54, {1,2,3,4,5,6}))

The function is working exactly like I want. However, now I would like to create a conditional formatting rule for that same range of cells so that if a cell was used in the SUMPRODUCT calculation it will be highlighted. Can anyone help me with that. Thanks!!

 

[Momentman]

Select cells B45:B54 and then use a formula like this in the conditional formatting
=$B45>=LARGE($B$45:$B454,6)