خرید بک لینک

I'm trying to find a way to easily identify the first ten rows in a table column, no matter how it's been sorted/filtered. Is there a way to use conditional formatting to highlight these cells?

Examples of desired results...

Sample data:

product price   units   code
Item02  15.97   2191    7UQC
Item05  12.95   1523    TAAI
Item13  9.49    1410    LV9E
Item01  5.69    591     6DOY
Item04  15.97   554     ZCN2
Item08  10.68   451     2GN0
Item03  13.95   411     FP6A
Item07  25.45   174     PEWK
Item09  14.99   157     B5S4
Item06  18      152     XJ4G
Item10  11.45   148     BY8M
Item11  16.99   66      86C2
Item12  24.5    17      X31K
Item14  24.95   14      QJEI

  1. When sorting by price the first 10 products highlighted differ from those in the next example.

table of products sorted by price

  1. The first 10 visible products are highlighted after filtering out Item12, Item05, and Item08.

table of products with items 12, 05, and 08 filtered out

برچسب: نویسنده: استخدام کار تاريخ: سه شنبه 14 ارديبهشت 1395 ساعت: 1:43

صفحه بندی