یکشنبه بیست و سوم آذر ۱۳۹۹ - 15:22 - حسين حسين پور -
Highlight top values
Generic formula
=A1>=LARGE(data,N)
Summary
To highlight the highest values in a set of data with conditional formatting, you can use a formula based on the LARGE function.
In the example shown, the formula used for conditional formatting is:
=B4>=LARGE(data,input)
با نام و یاد خدا