Conditionally format a cell based on another cells conditional format

just use the same rule in column B
=$E5>=LARGE($E$5:$E$14,$E$3)
to highlight B

or is that NOT what you meant





for 2007, 2010 , 2013 , 2016 , 2019 or 365 Subscription excel version
Conditional Formatting

Highlight applicable range >>
B5:B100 - Change, reduce or extend the rows to meet your data range of rows

Home Tab >> Styles >> Conditional Formatting
New Rule >> Use a formula to determine which cells to format
Edit the Rule Description: Format values where this formula is true:
=$E5>=LARGE($E$5:$E$14,$E$3)

Format [Number, Font, Border, Fill]
choose the format you would like to apply when the condition is true
OK >> OK

So the top three percentages are in cells E7, E8, & E12. The corresponding numbers are 2, 3, & 7 respectively from column D. I would like the same corresponding numbers in column B to also highlight. In this case any cell that has the number 2, 3, or 7.

what version of excel
this may be a messy answer - BUT needs to have the FILTER() function

AND another member maybe able to see a MUCH simpler solution

=ISNUMBER(MATCH($B4,FILTER($D$5:$D$14,$E$5:$E$14>=LARGE($E$5:$E$14,$E$3)),0))

maybe very slow and may need a helper column



OR you can use a helper column and use the extreacted numbers that match
=SUM(COUNTIFS(B4,$G$5#))



and if an earlier version - should be able to pull out the list without an FILTER()

Good information. Didn't use verbatim but was able to tweak it to work based on what you provided. I did use a helper column.

great you are welcome

i would still add the version of excel
What version of excel are you using - would be worth updating your profile to show version as solutions will be dependant on what version you have and therefore what functions available.
Excel Versions are: 2003/2007/2010/2013/2016/2019/2021/2024 (due April24) /365 subscription , also rather than show more than 1 version . if you have them , show which version you will be using the solution for.
An awful lot of new functions have now been added to the newer versions