Pivot table highliting customers only.

HI Everyone,



can anyone help me with out with a pivot table, I know how to do them, however, I am trying to see if I can highlite only certain cells. The cells are the customers. each customer has radios, but I just want to highlite the cell that shows the customer's name.

The pivot table is on "SHEET 1". the customers are "AAR/LAX" or "ANA/LAX" they are all the letter code follow with a "/LAX".


thanks

Hover your mouse towards the top of cell A4 until your pointer turns into a black down arrow and left-click.

Then with all of the names selected, right-click > format cells > Fill > select a color > OK

Thank you for the rep!

If this solved your problem, please mark this thread as SOLVED.