Conditional formating using named cell

[Peter]

Hi.
In a pivottable in Excel 07 I have the monthly results for a
department. I use conditional formating to indicate if the spend value
for year to date exceeds the total-year-plan with more than a certain
pct.

This pct will change over the year, depending on the month shown.

Till now I have typed the value in the conditional formating:
=($J9*4/12)<$G9

[J is total-year-plan and G is the spend value for year to date.]

I would like to make the formula dynamic, and have it to refer to a
cell called ValueForRed.

I have tried to tye =($J9*ValueForRed)<$G9 but it does not work.

Any suggestions ?

Med venlig hilsen
Åeter

 

[Peter]

Hi.

Don't realy know what was wrong.

I tried again, and now it's o.k.

Sorry.

Peter