Question: Conditional Formatting Excel - What formula would i use with conditional formatting for the question below? Customer - First Purchase: *Use conditional formatting to format
Conditional Formatting Excel - What formula would i use with conditional formatting for the question below?


Customer - First Purchase: *Use conditional formatting to format those purchase dates where the buyer was over 30 years old when the purchase was made with bold, orange. H 1 Customerkey wn 11008 C D GeographyKey FirstName LastName 11000 26 Jon Yang 11001 37 Eugene Huang 11002 31 Ruben Torres 11003 11 Christy Zhu 11004 19 Elizabeth Johnson 11005 22 Julio Ruiz 11006 8 Janet Alvarez 11007 40 Marco Mehta 32 Rob Verhoff 11009 25 Shannon Carlson 11010 22 Jacquelyn Suarez 11011 22 Curtis Lu 11012 611 Lauren Walker 11013 543 lan Jenkins 11014 634 Sydney Bennett 11015 301 Chloe Young 11016 329 Wyatt Hill 11017 39 Shannon Wang 11018 32 Clarence Rai 11019 52 Luke Lal 53 Jordan King 11021 536 Destiny Wilson 11022 609 Ethan Zhang 11023 298 Seth Edwards 11024 311 Russell Xie 11025 24 Alejandro Beck 11026 4 Harold Sai 11027 40 Jessie Zhao 17 Jill Jimenez 11029 32 Jimmy Moreno 11030 28 Bethany Yuan 11031 8 Theresa Ramos E F G I J K BirthDate MaritalStatu: Gende EmailAddress Yearlyincom TotalChildre Date First Purchase 4/8/1966 M M jon24@adventure-works.com 90,000.00 7/22/2005 5/14/1965 S M eugene1o@adventure-works.com 60,000.00 7/18/2005 8/12/1965 M M ruben35@adventure-works.com 60,000.00 7/10/2005 2/15/1968 S F christy12@adventure-works.com 70,000.00 7/1/2005 8/8/1968 S elizabeth5@adventure-works.com 80,000.00 7/26/2005 8/5/1965 S M juliol@adventure-works.com 70,000.00 7/2/2005 12/6/1965 S F janet9@adventure-works.com 70,000.00 7/27/2005 5/9/1964 M M marco14@adventure-works.com 60,000.00 7/12/2005 7/7/1964 S F rob4@adventure-works.com 60,000.00 7/28/2005 4/1/1964 S shannon38@adventure-works.com 70,000.00 7/30/2005 2/6/1964 S F jacquelyn20@adventure-works.con 70,000.00 7/17/2005 11/4/1963 M M curtis9@adventure-works.com 60,000.00 7/2/2005 1/18/1968 M F lauren41@adventure-works.com 100,000.00 9/17/2007 8/6/1968 M M ian47@adventure-works.com 100,000.00 10/15/2007 5/9/1968 S F sydney23@adventure-works.com 100,000.00 9/24/2007 2/27/1979 S F chloe23@adventure-works.com 30,000.00 7/22/2007 4/28/1979 M M wyatt32@adventure-works.com 30,000.00 8/13/2007 6/26/1944 S shannon1@adventure-works.com 20,000.00 7/15/2005 10/9/1944 S clarence32@adventure-works.com 30,000.00 7/20/2005 3/7/1978 S M luke18@adventure-works.com 40,000.00 8/16/2007 9/20/1978 S M jordan73@adventure-works.com 40,000.00 7/2/2007 9/3/1978 S F destiny7@adventure-works.com 40,000.00 7/27/2007 10/12/1978 M M ethan20@adventure-works.com 40,000.00 7/24/2007 10/11/1978 M M seth46@adventure-works.com 40,000.00 8/21/2007 9/17/1978 M M russell7@adventure-works.com 60,000.00 12/29/2007 12/23/1945 M M alejandro45@adventure-works.com 10,000.00 7/9/2005 4/3/1946 S M harold3@adventure-works.com 30,000.00 7/26/2005 12/7/1946 M jessie16@adventure-works.com 30,000.00 7/19/2005 4/11/1946 M F jill13@adventure-works.com 30,000.00 7/29/2005 12/21/1946 M M jimmy9@adventure-works.com 30,000.00 7/22/2005 2/22/1947 M F bethany10@adventure-works.com 10,000.00 8/8/2005 8/22/1947 M F theresa13@adventure-works.com 20,000.00 8/4/2005 11020 11028
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
