\begin{tabular}{|l|l|c|} \hline \multicolumn{1}{|c|}{ Seller } & \multicolumn{1}{|c|}{ Item } & Quantity \\ \hline Ahmad & Laptop & 5 \\ \hline Ahmad & Laptop & 5 \\ \hline Ahmad & Laptop & 4 \\ \hline Ahmad & Smartphone & 4 \\ \hline Ahmad & Smart watch & 3 \\ \hline Ahmad & TV & 4 \\ \hline Ahmad & Speaker & 5 \\ \hline Ahmad & Smart watch & 4 \\ \hline Ahmad & Smartphone & 2 \\ \hline Ahmad & Laptop & 4 \\ \hline Ahmad & Smart watch & 5 \\ \hline Ahmad & TV & 4 \\ \hline Alia & Laptop & 3 \\ \hline Alia & Smartphone & 2 \\ \hline Alia & Smart watch & 1 \\ \hline Alia & TV & 3 \\ \hline Alia & Speaker & 3 \\ \hline Alia & Smart watch & 4 \\ \hline Alia & Smartphone & 4 \\ \hline Alia & Speaker & 2 \\ \hline Alia & Laptop & 1 \\ \hline Alia & Smartphone & 3 \\ \hline Alia & Smart watch & 4 \\ \hline Alia & TV & 4 \\ \hline Alia & TV & 3 \\ \hline Alia & Smart watch & 2 \\ \hline Alia & Smartphone & 1 \\ \hline Alia & Laptop & 1 \\ \hline Alia & Smart watch & 2 \\ \hline Alia & TV & 3 \\ \hline Alia & Speaker & 4 \\ \hline Alia & Smart watch & 4 \\ \hline Alia & Laptop & 4 \\ \hline \end{tabular} Add conditional formatting to the "Item" column as follow: 1- Laptop: light red fill with dark red text 2-Smartiphonea lishit vellow fill with dark yel low text 3-Smart watch: light green fill with dark green text Create a pivot table as follow: 1- Filter: Seller 2- Row Lables: Item 3-Values: Quantity Refer to the "Pivot Tabl, How To" video on Teaching Materia 1- Select the Item column Click Conditional Formatting in the Home tab 2- Click on Highlight Cells Rules-->Text That Contains 3- Type the item name in the empty field, choose the formatting from the Format With drop list, click OK