Make the following changes:
1) Put an X to mark the appropriate cells to show that everyone in Sales attended Part 2
2) Highlight the cells and fill the cells with Red containing the names of the individuals in Claims that did not attend Part 3
3) Format Column H to be 'Currency' with 2 decimal places. Be sure it includes the $ automatically.
4) Each individual must pay $25 for each session they attended. Using a formula of your choice, fill Column H with the total owed for sessions attended, subtracting anything already paid. You may choose to add a header. (Hint: IF or COUNTIF are two possible choices)
5) Sort the entire file (except the headers) A-Z by Last name
6) Add a filter to all Columns, but do not filter the file
7) Bold 'Total Paid'
8) Add conditional formatting to the Total Owed cell for anyone who owes more than $25 for the conference. Have the cell turn red if the total owed is more than $25.
how do I do, uhh, any of this
