def test_conditional_formatting_add3ColorScale(self): cf = ConditionalFormatting() cf.add3ColorScale('B1:B10', 'percentile', 10, 'FFAA0000', 'percentile', 50, 'FF0000AA', 'percentile', 90, 'FF00AA00') rules = cf.cf_rules assert 'B1:B10' in rules assert len(cf.cf_rules['B1:B10']) == 1 assert rules['B1:B10'][0]['priority'] == 1 assert rules['B1:B10'][0]['type'] == 'colorScale' assert rules['B1:B10'][0]['colorScale']['cfvo'][0]['type'] == 'percentile' assert rules['B1:B10'][0]['colorScale']['cfvo'][0]['val'] == '10' assert rules['B1:B10'][0]['colorScale']['cfvo'][1]['type'] == 'percentile' assert rules['B1:B10'][0]['colorScale']['cfvo'][1]['val'] == '50' assert rules['B1:B10'][0]['colorScale']['cfvo'][2]['type'] == 'percentile' assert rules['B1:B10'][0]['colorScale']['cfvo'][2]['val'] == '90'