P
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
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