Spreadsheet: 235881d1368628837-simple-conditional-formatting-example
Sheet: Sheet1

seller-sku | estimated-referral-fee-per-item | NEW fee | price
AGF23A | 0.5 |  | 1.07
AGF27AB5 | 0.5 |  | 2.34
AGF4LR44 | 0.5 |  | 1.2
AGF6LR61 | 0.5 |  | 2.96
AGF9VLIT | 0.7 |  | 5.8
AGFAA1300 | 0.58 |  | 4.85
AGFAA2100 | 0.66 |  | 5.54
AGFAAALITB2 | 0.5 |  | 3.4
AGFAALITB2 | 0.5 |  | 3.58
AGFCH41300 | 0.9 |  | 7.47
AGFCR1220 | 0.5 |  | 1.35
AGFCR123A | 0.5 |  | 3.33
AGFCR1616 | 0.5 |  | 0.98
AGFCR2 | 0.5 |  | 2.93
AGFCR2016 | 0.5 |  | 1.24
AGFCR2016B5 | 0.5 |  | 1.54
AGFCR2025 | 0.5 |  | 1.25
AGFCR2025B5 | 0.5 |  | 1.54
AGFCR2032 | 0.5 |  | 1.25
AGFCR2032B5 | 0.5 |  | 2.01
AGFCR2430 | 0.5 |  | 1.13
AGFCR2450 | 0.5 |  | 1.74
AGFFAMILY | 2.4 |  | 19.98
AGFLR03B10 | 0.5 |  | 3.79
AGFLR1 | 0.5 |  | 1.04
AGFLR14 | 0.5 |  | 3.62
AGFLR20 | 0.5 |  | 3.98
AGFLR44 | 0.5 |  | 1.36
AGFLR44B10 | 0.5 |  | 1.59
AGFLR6 | 0.5 |  | 1.96
AGFLR6B10 | 0.68 |  | 5.69
AGFR03R | 0.5 |  | 1.25
AGFR03RB12 | 0.5 |  | 3.26
AGFR14R | 0.5 |  | 2.92
AGFR20R | 0.5 |  | 3.09
AGFR6F22R | 0.5 |  | 1
AGFR6R | 0.5 |  | 1.01
AGFR6RB12 | 0.5 |  | 3.27
AGFSDHCC416GB | 1.62 |  | 13.52
AGFSDHCC44[NAME] | 1.31 |  | 10.92
AGFSDHCC48GB | 1.08 |  | 8.97
AGFSDHCPLUSC416GB | 1.74 |  | 14.52
AGFSDHCPLUSC48GB | 1 |  | 8.32
[NAME] | 2.31 |  | 19.28
AGFUSB28GB | 1.5 |  | 12.54
[NAME] | 3.19 |  | 26.56
DUR1_3N | 0.5 |  | 2.88
DUR223 | 0.66 |  | 5.52
DUR245 | 0.56 |  | 4.67
DUR364 | 0.5 |  | 2.18
DUR377 | 0.5 |  | 1.76
DUR392 | 0.27 |  | 1.79
DUR7K67 | 0.5 |  | 3.31
DUR9V170 | 1.02 |  | 6.77
DURAA1700 | 0.67 |  | 5.61
[NAME] | 0.9 |  | 7.53
DURAA2450B4 | 0.84 |  | 6.99
DURAAA1000 | 0.92 |  | 7.67
DURAAA750 | 0.72 |  | 5.99
DURAAAA | 0.5 |  | 4.04
DURAAAPPIX | 0.77 |  | 5.15
DURAAPPIX | 0.59 |  | 3.9
DURBUNDLE1 | 3 |  | 24.99
DURC2200 | 1.59 |  | 10.58
DURCEF22 | 3.24 |  | 21.57
DURCR1616 | 0.5 |  | 1.46
DURCR2016 | 0.19 |  | 1.24
DURCR2025 | 0.19 |  | 1.28
DURCR2032 | 0.19 |  | 1.28
DURCR2450 | 0.5 |  | 1.88
DURCRV3 | 0.66 |  | 5.49
DURD2200 | 1.58 |  | 10.52
DURLITAA | 0.68 |  | 5.68
DURLR43 | 0.26 |  | 1.75
DURLR44 | 0.2 |  | 1.35
DURMN1203 | 0.5 |  | 3.56
DURMN1300 | 0.68 |  | 4.56
DURMN1300M3 | 0.73 |  | 4.88
DURMN1400 | 0.68 |  | 4.56
DURMN1400M3 | 0.73 |  | 4.88
DURMN1500 | 0.45 |  | 2.99
DURMN1500B2BASE | 0.5 |  | 3.53
[NAME] | 0.5 |  | 3.48
DURMN1500B5_3 | 0.54 |  | 4.49
[NAME] | 0.35 |  | 2.32
DURMN1500M3 | 0.52 |  | 3.45
DURMN1500M3B5_3 | 0.59 |  | 4.95
DURMN1500RP | 0.5 |  | 2.42
DURMN1604 | 0.4 |  | 2.68
DURMN1604B8 | 1.4 |  | 11.64
DURMN1604M3 | 0.45 |  | 3.03
DURMN21B2 | 0.5 |  | 1.81
DURMN2400 | 0.42 |  | 2.8
DURMN2400B2BASE | 0.5 |  | 3
DURMN2400B4_2 | 0.5 |  | 3.57
DURMN2400B5_3 | 0.67 |  | 4.49
[NAME] | 0.34 |  | 2.26
DURMN2400M3 | 0.52 |  | 4.33
DURMN2400M3B5_3 | 0.59 |  | 4.95
DURMN2400UPB4_4 | 0.51 |  | 4.28
DURMN27 | 0.5 |  | 1.64
DURUSB3HR | 2.86 |  | 23.85
DURVOY | 0.89 |  | 7.42
[NAME] | 0.43 |  | 2.88
DURZA13 | 0.43 |  | 2.85
[NAME] | 0.45 |  | 2.98
ENE1025 | 0.5 |  | 1.63
ENE1216 | 0.5 |  | 1.63
[NAME] | 0.5 |  | 1.61
ENE1225 | 0.5 |  | 3.44
ENE123 | 0.5 |  | 2.54
ENE1616 | 0.5 |  | 1.69
ENE1620 | 0.5 |  | 1.45
ENE2012 | 0.5 |  | 1.99
ENE2016 | 0.5 |  | 1.28
ENE2025 | 0.5 |  | 1.29
ENE2032 | 0.5 |  | 1.32
[NAME] | 0.5 |  | 3.94
ENE23A | 0.2 |  | 1.36
ENE2430 | 0.5 |  | 2.78
ENE2450 | 0.5 |  | 2.15
ENE315 | 1.37 |  | 11.45
ENE317 | 1.29 |  | 10.77
ENE319 | 1.48 |  | 12.37
ENE321 | 1.29 |  | 10.77
ENE329 | 1.21 |  | 10.09
ENE335 | 2.71 |  | 22.58
ENE337 | 1.56 |  | 13.04
ENE344 | 2.63 |  | 21.9
ENE346 | 2.6 |  | 21.67
ENE357 | 1.81 |  | 15.09
ENE362 | 1.29 |  | 10.77
ENE364 | 0.99 |  | 8.28
ENE371 | 1.27 |  | 10.55
ENE373 | 1.37 |  | 11.45
ENE377 | 1.02 |  | 8.5
ENE379 | 0.96 |  | 7.98
ENE386 | 2.06 |  | 17.13
ENE391 | 1.48 |  | 12.37
ENE392 | 1.16 |  | 9.64
ENE393 | 1.79 |  | 14.94
ENE394 | 1.56 |  | 13.04
ENE395 | 1.2 |  | 9.98
ENE397 | 1.32 |  | 10.97
ENE6LR61 | 0.76 |  | 5.08
ENE6LR61UP | 0.59 |  | 3.93
ENEA76 | 0.5 |  | 1.36
ENEFLBOOK | 1.41 |  | 9.4
ENEFLCOMLED3AA | 1.02 |  | 6.82
ENEFLDIY | 2.62 |  | 17.49
ENEFLIMP2AAALED | 0.86 |  | 7.17
ENEFLIMP2AALED | 1.71 |  | 11.39
ENEFLPRO4LED | 2.04 |  | 13.61
ENEKPR113 | 0.61 |  | 4.08
ENEL91 | 0.5 |  | 4.04
ENEL91B4 | 1.05 |  | 8.78
ENEL92 | 0.54 |  | 4.54
ENEL92B4 | 1.05 |  | 8.78
ENEL9VB1 | 1 |  | 8.34
ENELR1 | 0.5 |  | 2.1
ENELR14 | 0.51 |  | 4.21
ENELR14UP | 0.57 |  | 4.79
ENELR20 | 0.71 |  | 5.95
ENELR20UP | 0.6 |  | 4.99
ENELR6 | 0.75 |  | 5.03
ENELR6UP | 0.44 |  | 2.92
ENELRO3 | 0.6 |  | 5.03
ENELRO3UP | 0.45 |  | 2.97
ERAD28 | 0.73 |  | 6.09
ERFLLED1D | 1.2 |  | 7.97
ERFLVPT1 | 1.63 |  | 13.58
ERPJ991 | 1.29 |  | 8.58
ERPJ996 | 0.53 |  | 4.43
ERPP3 | 0.5 |  | 1.49
ERPP9 | 0.69 |  | 5.76
ERR03 | 0.22 |  | 1.44
ERR14 | 0.52 |  | 3.48
ERR14S | 0.5 |  | 3.41
ERR20 | 0.45 |  | 3.74
ERR20S | 0.5 |  | 3.7
ERR6 | 0.18 |  | 1.48
FAMCP06U | 0.73 |  | 6.08
FAMCP08 | 0.69 |  | 5.77
FAMCP08U | 0.69 |  | 5.77
FAMCP13U | 0.5 |  | 0.76
FAMCP40 | 0.68 |  | 5.63
FAMCP46 | 1.29 |  | 10.77
FAMCP49 | 1.14 |  | 9.52
FAMCP50 | 1.18 |  | 9.85
FUNFLASH | 0.43 |  | 6.17
GP10AB5 | 0.5 |  | 2.74
GP11A | 0.5 |  | 1.38
GP164 | 0.5 |  | 1.48
[NAME] | 0.5 |  | 3.12
GP23A | 0.5 |  | 1.47
GP23AB5 | 0.5 |  | 2.5
GP27A | 0.5 |  | 1.77
GP27AB5 | 0.56 |  | 4.63
GP384 | 0.61 |  | 5.06
GP386 | 1.09 |  | 9.11
GP391 | 1.14 |  | 9.47
GP397 | 0.54 |  | 4.52
GP476A | 0.5 |  | 1.54
GP9VRECYKO | 0.68 |  | 5.68
GP9VULT | 0.5 |  | 2.13
GPA76 | 0.5 |  | 1.07
GPA76B10 | 0.5 |  | 2.17
GPAA2100B4 | 1.06 |  | 8.85
GPAA2500B4 | 1.04 |  | 8.69
GPAAA1000B4 | 0.65 |  | 5.39
GPAAA650EKO | 0.58 |  | 4.84
GPAAAA | 0.5 |  | 1.56
GPAAARECYKO | 0.84 |  | 7
GPAAAULT | 0.5 |  | 1.78
GPAAAULTB24 | 1.09 |  | 9.11
GPAAAULTB4_2 | 0.5 |  | 2.05
GPAAAUP | 0.5 |  | 1.85
GPAARECYKO | 1.32 |  | 11
GPAAULT | 0.5 |  | 1.78
GPAAUP | 0.5 |  | 3.78
GPAR540 | 3.05 |  | 25.39
GPCR1220 | 0.5 |  | 1.16
GPCR123 | 0.5 |  | 2.56
GPCR1616 | 0.5 |  | 1.2
[NAME] | 0.5 |  | 3.1
GPCR2016 | 0.5 |  | 1.07
GPCR2016B5 | 0.5 |  | 1.94
[NAME] | 0.5 |  | 1.94
GPCR2032 | 0.5 |  | 1.07
GPCR2032B5 | 0.23 |  | 1.94
GPCR2430 | 0.5 |  | 3.43
GPCRECYKO | 1.15 |  | 9.57
GPCULT | 0.5 |  | 4.05
GPDRECYKO | 1.17 |  | 9.78
GPDULT | 0.52 |  | 4.3
GPLCE202 | 0.87 |  | 7.22
GPLOE205 | 1.56 |  | 12.97
GPLOE404 | 6.5 |  | 54.14
GPLR1B2 | 0.5 |  | 1.61
GPPB19 | 2.39 |  | 19.93
GPPJ996 | 0.86 |  | 7.18
GPPP9 | 1.5 |  | 12.47
GPR14G | 0.5 |  | 3.3
GPR20G | 0.5 |  | 3.45
GPXPB28 | 3.32 |  | 27.64
GPZA675 | 0.61 |  | 4.08
KC20024 | 0.89 |  | 7.38
KC20036 | 0.91 |  | 7.58
LLOD965 | 0.84 |  | 5.6
PAN2CR5 | 0.5 |  | 3.69
PAN6F22R | 0.5 |  | 1.34
PAN6LR61PP | 0.5 |  | 2.39
PANBF310 | 0.73 |  | 4.86
PANBFPLVC | 1.74 |  | 14.49
PANBQ326 | 2.15 |  | 17.91
PANCR1025 | 0.5 |  | 2.33
PANCR1216 | 0.5 |  | 1.56
PANCR1220 | 0.5 |  | 1.79
PANCR1616 | 0.5 |  | 1.54
PANCR1620 | 0.5 |  | 1.63
PANCR1632 | 0.5 |  | 1.95
PANCR2 | 0.5 |  | 2.88
PANCR2016 | 0.5 |  | 1.42
PANCR2016B6 | 0.5 |  | 2.76
PANCR2025B6 | 0.5 |  | 2.76
PANCR2032 | 0.5 |  | 1.38
PANCR2430 | 0.5 |  | 3.41
PANCR2450 | 0.5 |  | 3.11
[NAME] | 0.5 |  | 3.75
PANF6X2PE103 | 1.35 |  | 11.27
PANLR03APBB10 | 0.59 |  | 4.9
PANLR03EB4 | 0.5 |  | 3.61
PANLR03PP | 0.5 |  | 2.69
PANLR03PPB8 | 0.5 |  | 3.81
PANLR1 | 0.5 |  | 1.54
PANLR14PP | 0.5 |  | 3.92
PANLR20APB | 0.57 |  | 4.79
PANLR20PP | 0.55 |  | 4.56
PANLR44 | 0.5 |  | 1.29
PANLR6APBB10 | 0.62 |  | 5.15
PANLR6APBB4_2 | 0.5 |  | 2.01
PANLR6EB4 | 0.5 |  | 3.61
PANLR6PP | 0.5 |  | 2.88
PANLR6PPB8 | 0.5 |  | 3.74
PANP03B2_800 | 0.67 |  | 5.56
PANP6IB4 | 1.21 |  | 10.12
PANP6PB4_2600 | 1.86 |  | 15.49
PANPJ996 | 0.52 |  | 4.37
PANR14R | 0.5 |  | 3.07
PANR20R | 0.5 |  | 3.22
PANR6R | 0.5 |  | 1.95
PANRO3R | 0.5 |  | 1.35
PANZA13 | 0.5 |  | 2.86
PHI23A | 0.5 |  | 1.34
PHI6F22 | 0.5 |  | 1.71
PHI6LR61 | 0.5 |  | 2.48
PHI6LR61EX | 0.5 |  | 3.37
PHI9VB1 | 1.08 |  | 8.98
PHIA76 | 0.5 |  | 1.28
PHIAA1300B4 | 0.7 |  | 5.84
PHIAA2000B4RTU | 1.01 |  | 8.4
PHIAA2450B4 | 1.26 |  | 10.52
PHIAA2700B4 | 1.49 |  | 12.43
PHIC2450B2 | 0.89 |  | 7.42
PHICR123 | 0.5 |  | 2
PHICR1616 | 0.5 |  | 1.46
PHICR1620 | 0.5 |  | 1.43
[NAME] | 0.5 |  | 2.31
PHICR2016 | 0.5 |  | 1.43
PHICR2025 | 0.21 |  | 1.38
PHICR2032 | 0.5 |  | 1.38
PHICR2430 | 0.3 |  | 2.01
PHILITAA | 0.72 |  | 5.98
PHILITAAA | 0.68 |  | 5.65
PHILR03 | 0.41 |  | 2.72
PHILR03EX | 0.5 |  | 3.01
PHILR1 | 0.59 |  | 3.95
PHILR14 | 0.5 |  | 3.86
PHILR14EX | 0.7 |  | 5.81
PHILR20 | 0.77 |  | 6.43
PHILR20EX | 0.57 |  | 4.76
PHILR6 | 0.5 |  | 2.68
PHILR6B12 | 0.5 |  | 3.3
PHILR6B32 | 0.87 |  | 7.27
PHILR6B8 | 0.5 |  | 2.49
PHILR6EX | 0.5 |  | 3.34
PHILR9 | 0.5 |  | 1.76
PHIR14 | 0.5 |  | 4.02
PHISFL2001 | 1.17 |  | 7.8
PHISFL3463 | 0.72 |  | 5.99
UNIAA1600M | 1.67 |  | 13.93
UNIONPJ996 | 0.5 |  | 3.77