$5.$ Gabriel created a macro named Bottom that highlights the bottom $5$ percent of values. However, Gabriel wants the macro to highlight the bottom four values to match the new Top macro.

Modify and test the Bottom macro as follows:

a$.$ Open the Bottom macro in the Visual Basic Editor.

b$.$ After the $.$TopBottom $=$ xlTop$10$Bottom line of code, change the $.$Rank $=5$ line of code to $.$Rank $=4$ so that the highlighting rule identifies the bottom four values.

c$.$ Change the $.$Percent $=$ True line of code to $.$Percent $=$ False so that the highlighting rule selects values rather than a percentage of values.

d$.$ Use the Bottom $4$ button to run the Bottom macro and highlight the bottom four items sold for the week.