3 ways to display meaningful information in Excel ... the Variance column). From the dropdown choose Filter By Color and then select Red (the only color in the example) as shown in Figure D.