The Ropers is an American sitcom that aired on ABC from March 13, 1979 to May 22, 1980. It is a spin-off of Three's Company and loosely based on the British sitcom George and Mildred, which was itself a spin-off of Man About the House, on which Three's Company was based.
As well as coloring the people in the pivot table, you can sort your source data by name, create a new column and instead of assigning a color to the names, assign a status value in the new column, active or inactive. Then include that new column in the pivot table and you can filter on it. cheers, Register To Reply.
1 Click on the down-facing triangle in the columnâs heading you want to sort the table by, and choose your sort option at the top of the drop-down menu. 2  Color. 3  Whether you apply a background fill or font color manually or by using conditional formatting, you can use that color to sort your data.n the Mac version, youâll find the table formatting options under the Tables tab because it would just make too much sense for Microsoft to keep the UIs between the two platforms parallel. Excel design for PC and Mac-Click for larger image. In any case, these tabs offer a plethora of additional formatting options.