Conditional Formatting

In this project, we integrated data validation, conditional formatting, and calculations with lookups. In this instance, conditional formatting was used to help users input correct and complete information. Using VLOOKUP and MATCH statements, the blue fields represent information drawn from different worksheets based on user inputs. On these secondary sheets, we practiced naming Table Arrays, Lookup Arrays, and Menus.