A List Contains the Names of Members of a Library,and

Multiple Choice

A list contains the names of members of a library,and the date of their joining.Which of the following can be achieved using conditional formatting?

A) Hide all names who have been members for more than five years.
B) Create a sublist of members whose names began with an "A."
C) Highlight cells of members who became members in a particular month.
D) Hide rows containing joining details of members who joined after a specified date.