How can I set up a milestone report with red/green/amber alerts
 

Hi
I would like to set up a period report which displays a set of milestones
and measures each of them against a baseline reference giving a couloured
indication: green if on track; amber say 10% out; and red, more than 10% out.
can you help

How can I set up a milestone report with red/green/amber alerts
 

Hi JPG,

Sounds like conditional formatting could be what you're loofing for. It
allows you to format a cell for color etc. when various preset conditions
are met. You'll find it on the Format drop down.

HTH
Martin

How can I set up a milestone report with red/green/amber alerts
 

See http://xldynamic.com/source/xld.CF.html#lights

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"JPG" wrote in message
...
Hi
I would like to set up a period report which displays a set of milestones
and measures each of them against a baseline reference giving a couloured
indication: green if on track; amber say 10% out; and red, more than 10%
out.
can you help

How can I set up a milestone report with red/green/amber alerts
 

Great link Bob, you just took my conditional formatting to a new level!

How can I set up a milestone report with red/green/amber alerts
 

Glad you liked it. Hope the OP does too <g

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"MartinW" wrote in message
...
Great link Bob, you just took my conditional formatting to a new level!

How can I set up a milestone report with red/green/amber alert
 

"Bob Phillips" wrote:

Glad you liked it. Hope the OP does too <g

--
HTH

Bob Phillips
Hi Bob & Martin,
Many thanks for your interest and help.
That is just what I needed very grateful.
cheers
Jack

(remove nothere from email address if mailing direct)

"MartinW" wrote in message
...
Great link Bob, you just took my conditional formatting to a new level!