Apply conditional formatting to column D. TRUE values should be formatted to display with a green fill with dark green text. FALSE values should be formatted to display with a light red fill with dark red text. DID I DO IT RIGHT?

Home insert Draw Page Layout Formulas Data Review view Tell me 9 Share V Comments A. Ini TT v % V Conditional Formatting 2 Format as Table Cell Styles O Com IN Analyze Data Paste Font Alignment Number Cells Editing Sensitivity G10 xv fx A A D E F G H 1 J K L M Customer # Loyalty Card 1 1000 2 3 Rank by # of Purchases in June 53 46 58 69 4 TRUE TRUE FALSE TRUE FALSE FALSE TRUE 5 6 7 8 23 9 1001 1002 1003 1004 1005 1006 1007 1008 1009 1010 1011 1012 1013 TRUE 32 69 8 16 46 10 11 12 69 13 FALSE FALSE FALSE TRUE FALSE TRUE FALSE 89 OOOO 14 53 89 15 16 1014 B # of Age Category Purchases in June 22-25 O 4 30-35 5 26-30 IO 3 18-21 IO 1 30-35 a 12 26-30 O 9 30-35 lo 1 1 30-35 lo 18 30-35 o 14 30-35 IO 5 5 30-35 1 18-21 0 22-25 4 18-21 0 18-21 O 1 over 35 10 1 30-35 1 26-30 11 30-35 11 18-21 O 0 30-35 3 26-30 IO 1 18-21 la 1 22-25 10 1 18-21 0 22-25 13 26-30 5 over 35 IO 4 4 22-25 14 over 35 O 12 18-21 0 18-21 lo 1 26-30 O 12 22-25 O 3 3 17 18 19 20 1015 1016 1017 1018 1019 1020 69 69 69 27 27 89 58 69 69 21 22 23 24 25 1021 69 26 27 1022 1023 1024 1025 1026 1027 1028 1029 TRUE TRUE FALSE FALSE FALSE TRUE TRUE TRUE TRUE FALSE FALSE FALSE FALSE FALSE FALSE TRUE TRUE TRUE FALSE 28 29 30 31 32 33 89 19 46 53 16 23 89 69 23 58 1030 34 1031 1032 1033 35 10A 11 TAI 40