named ranges in conditional formating inside a pivottable

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
 
B

Billy Liddel

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
 
Top