Spreadsheet: 773938d1648127329-conditional-formatting-based-on-1-cell-format-whole-row-example
Sheet: Report

 | Conditional formatingā! Bet vispirms vajag subtotals zem data uztaisīt | .=SEARCH("*Total*";$A12) |  | PIRMS MACRO NOMAINIT PUNKTUS UN KOMATUS PIE STUNDU LIKMEM
Random Stuff | Also random | Very random | Most random
 |  |  |  | Most Randomest | Randomestest | Totally random | [NAME] | Ultra random | Super duper random | RRRRRandom | RRANDOMO |  | Coimbo breaker
 |  |  |  | 1 | 168 | 3 | 4=2*3  vai 1*3 | 5 | 6=4*5 | 7=6*0.2359 | 8=6+7
KOPĀ
Something | Description | Title | 1 | 60 |  | 4.58 |  | 100% | 274.8 |  |  |  | 23,59%
Something | Description | Title | 2 | 48 |  | 4.58 |  | 100% | 219.84 |  |  |  | 23,59%
Something | Description | Title | 3 | 96 |  | 4.58 |  | 100% | 439.68 |  |  |  | 23,59%
Something | Description | Title | 5 | 84.5 |  | 8.12 |  | 100% | 686.14 |  |  |  | 23,59%
Something | Description | Title | 435 | 96 |  | 4.58 |  | 100% | 439.68 |  |  |  | 23,59%
Something | Description | Title | 4325324 | 24 |  | 7.08 |  | 100% | 169.92 |  |  |  | 23,59%
Something | Description | Title | 32 | 72 |  | 5.12 |  | 100% | 368.64 |  |  |  | 23,59%
Something | Description | Title | 423 | 72 |  | 8.12 |  | 100% | 584.64 |  |  |  | 23,59%
Something | Description | Title | 4 | 36 |  | 4.58 |  | 100% | 164.88 |  |  |  | 23,59%
Something | Description | Title | 324 | 24 |  | 6.79 |  | 100% | 162.96 |  |  |  | 23,59%
Something | Description | Title | 23 | 24 |  | 5.38 |  | 100% | 129.12 |  |  |  | 23,59%
Something | Description | Title | 423 | 60 |  | 5.25 |  | 100% | 315 |  |  |  | 23,59%
Something | Description | Title | 4 | 36.5 |  | 8.54 |  | 100% | 311.71 |  |  |  | 23,59%
Something | Description | Title | 324 | 108 |  | 5.38 |  | 100% | 581.04 |  |  |  | 23,59%
Something | Description | Title | 32 | 36.5 |  | 7.26 |  | 100% | 264.99 |  |  |  | 23,59%
Something | Description | Title | 4 | 24 |  | 6.37 |  | 100% | 152.88 |  |  |  | 23,59%
Something | Description | Title | 324 | 48 |  | 8.96 |  | 100% | 430.08 |  |  |  | 23,59%
Something | Description | Title | 32 | 36.5 |  | 8.54 |  | 100% | 311.71 |  |  |  | 23,59%
Something | Description | Title | 4 | 48 |  | 8.54 |  | 100% | 409.92 |  |  |  | 23,59%
Something | Description | Title | 23 | 24 |  | 8.54 |  | 100% | 204.96 |  |  |  | 23,59%
Something | Description | Title | 5 | 96 |  | 5.12 |  | 100% | 491.52 |  |  |  | 23,59%
Something | Description | Title | 546 | 24 |  | 8.02 |  | 100% | 192.48 |  |  |  | 23,59%
Something | Description | Title | 5 | 60.5 |  | 6.37 |  | 100% | 385.39 |  |  |  | 23,59%
Something | Description | Title | 7 | 64 |  | 7.94 |  | 100% | 508.16 |  |  |  | 23,59%
Something | Description | Title | 7 | 24 |  | 8.02 |  | 100% | 192.48 |  |  |  | 23,59%
Something | Description | Title | 6 | 48 |  | 5.12 |  | 100% | 245.76 |  |  |  | 23,59%
Something | Description | Title | 8 | 132.5 |  | 9.61 |  | 100% | 1273.33 |  |  |  | 23,59%
Something | Description | Title | 78 | 12.5 |  | 8.12 |  | 100% | 101.5 |  |  |  | 23,59%
Something | Description | Title | 7 | 84 |  | 4.58 |  | 100% | 384.72 |  |  |  | 23,59%
Something | Description | Title | 876
Something | Description | Title | 8 | 8 |  | 11.85 |  | 100% | 94.8 |  |  |  | 23,59%
Something | Description | Title | 76 | 14 |  | 10.84 |  | 100% | 151.76 |  |  |  | 23,59%
Something | Description | Title | 876 | 24 |  | 10.84 |  | 100% | 260.16 |  |  |  | 23,59%
Something | Description | Title | 8 | 28 |  | 11.02 |  | 100% | 308.56 |  |  |  | 23,59%
Something | Description | Title | 6 | 8 |  | 10.36 |  | 100% | 82.88 |  |  |  | 23,59%
Something | Description | Title | 15428 | 14 |  | 10.36 |  | 100% | 145.04 |  |  |  | 23,59%
Something | Description | Title | 56 | 14 |  | 11.08 |  | 100% | 155.12 |  |  |  | 23,59%
Something | Description | Title | 45 | 18 |  | 10.36 |  | 100% | 186.48 |  |  |  | 23,59%
Something | Description | Title | 64 | 41.5 |  | 11.08 |  | 100% | 459.82 |  |  |  | 23,59%
Something | Description | Title | 56 | 16 |  | 10.36 |  | 100% | 165.76 |  |  |  | 23,59%
Something | Description | Title | 54 | 8 |  | 10.6 |  | 100% | 84.8 |  |  |  | 23,59%
Something | Description | Title | 645 | 14 |  | 10.36 |  | 100% | 145.04 |  |  |  | 23,59%
Something | Description | Title | 64 | 38 |  | 10.7 |  | 100% | 406.6 |  |  |  | 23,59%
Something Total
Anything | Description | Title | 4 | 25 |  | 7.68 |  | 100% | 192 |  |  |  | 23,59%
Anything | Description | Title | 64 | 24 |  | 7 |  | 100% | 168 |  |  |  | 23,59%
Anything | Description | Title | 6 | 16 |  | 5.06 |  | 100% | 80.96 |  |  |  | 23,59%
Anything | Description | Title | 45 | 47 |  | 7.68 |  | 100% | 360.96 |  |  |  | 20,77%
Anything | Description | Title | 6 | 48 |  | 4.82 |  | 100% | 231.36 |  |  |  | 23,59%
Anything | Description | Title | 534 | 13.5 |  | 7.68 |  | 100% | 103.68 |  |  |  | 23,59%
Anything | Description | Title | 53 | 24 |  | 4.82 |  | 100% | 115.68 |  |  |  | 23,59%
Anything | Description | Title | 23 | 24 |  | 7.68 |  | 100% | 184.32 |  |  |  | 23,59%
Anything | Description | Title | 2 | 24 |  | 7.68 |  | 100% | 184.32 |  |  |  | 23,59%
Anything | Description | Title | 42 | 11.5 |  | 7.68 |  | 100% | 88.32 |  |  |  | 23,59%
Anything | Description | Title | 42 | 48 |  | 7.52 |  | 100% | 360.96 |  |  |  | 23,59%
Anything | Description | Title | 5 | 24 |  | 7.68 |  | 100% | 184.32 |  |  |  | 23,59%
Anything | Description | Title | 3 | 43 |  | 4.99 |  | 100% | 214.57 |  |  |  | 23,59%
Anything | Description | Title | 23 | 24 |  | 4.82 |  | 100% | 115.68 |  |  |  | 23,59%
Anything | Description | Title | 46 | 36.5 |  | 7.68 |  | 100% | 280.32 |  |  |  | 23,59%
Anything | Description | Title | 547 | 24 |  | 4.35 |  | 100% | 104.4 |  |  |  | 23,59%
Anything | Description | Title | 56 | 25 |  | 7.68 |  | 100% | 192 |  |  |  | 23,59%
Anything | Description | Title | 7 | 48 |  | 7.68 |  | 100% | 368.64 |  |  |  | 23,59%
Anything | Description | Title | 567 | 37.5 |  | 4.82 |  | 100% | 180.75 |  |  |  | 23,59%
Anything | Description | Title | 3 | 24 |  | 7.68 |  | 100% | 184.32 |  |  |  | 23,59%
Anything | Description | Title | 4 | 83.5 |  | 7.68 |  | 100% | 641.28 |  |  |  | 23,59%
Anything | Description | Title | 34 | 24 |  | 4.82 |  | 100% | 115.68 |  |  |  | 23,59%
Anything | Description | Title | 324 | 48 |  | 4.35 |  | 100% | 208.8 |  |  |  | 23,59%
Anything | Description | Title | 23 | 8 |  | 5.06 |  | 100% | 40.48 |  |  |  | 23,59%
Anything total
Yolo | Description | Title | 24 | 24 |  | 7.68 |  | 100% | 184.32 |  |  |  | 23,59%
Yolo Total
Anyhow | Description | Title | 4 | 12.5 |  | 7.08 |  | 100% | 88.5 |  |  |  | 20,77%
Anyhow | Description | Title | 234 | 24 |  | 7.68 |  | 100% | 184.32 |  |  |  | 23,59%
Anyhow Total
Grand Total