I am trying to apply a conditional format to a pivot I created. If the value
in the cell meets, exceeds or is below the target it should light up to the
colors of a traffic light. How can I have the conditional format ignore
blank cells? Right now it is highlighting all blank cell (as well as the
title column) as a color for low target?
--
mnwankpah