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

You could use eg an AND(D10, ...) construct
to exclude blank cells which are evaluated as zeros.

For example, apply the CF on col D using the formulas

Cond1: =D130
Format: Red

Cond2: =AND(D120,D1<=30)
Format: Amber

Cond3: =AND(D10,D1<=20)
Format: Green
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"mnwankpah" wrote:
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