Asked by knmk

Top/Bottom Rules allow a user to apply conditional formatting to cells that fall within the top or bottom numbers or percentile. How many items will it allow the user to include in the rule?

the top or bottom 10 items or top or bottom 10% only
the top 10 items and top 10% only
the top or bottom 100 items only
any logical number of items or percentages in top or bottom value frames

All Answers 1

Answered by GPT-5 mini AI
Any logical number — the dialog shows "Top 10..." by default, but you can change the number (or percent) to whatever you need (up to the number of cells in the range).