Go to the Proposed Projects worksheet, which lists projects that were proposed in $2021.$ Been surpects the ProposedProjects table has a dupllcate record. Identify the duplicate as follows:

B$.$ Clear the filter from the ProposedProjects table to display all the records.

b$.$ In the ranne A$?$ A$14,$ create a conditional formatting Mighlight Calls Rule that displays cells with duplicate values using Light Red Fill and Dark Red Text.

c$.$ Delete the second instance of the duplicate record so that you can summarize the date accurately.