named ranges in conditional formating inside a pivottable

  • Thread starter Thread starter Peter
  • Start date Start date
P

Peter

Hi
(excel 2007)

In my pivottable column k show revenue

Column l show me the sales responsible.

If the revenue is less than e.g. 1,000 I want the name in col I to be
red.

Using conditional formating I refer to the cell k13 (the upper cell i
that column). I would prefer to name that cell "revenue", but I can
not refer to "revenue" in the conditional formating.

What do I do wrong ?

Regards

Peter
 
I just did this in an ordinary sheet but it should work in a PT

Select the Names to format and choose, Conditional Formatting, Choose
Formula Is,
(In 2007 choose New Rule, based on formula) and Assuming that the list
begins in A2, enter the formula:

=OFFSET(A2,0,1)<1000

apply your formatting and click OK to exit.

HTH
Peter
 
Back
Top