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

[JPG]

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

[MartinW]

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

[Bob Phillips]

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"JPG" <JPG@discussions.microsoft.com> wrote in message
news:57B3E113-3C99-4179-A0F3-BE9607191225@microsoft.com...
> 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

[MartinW]

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

[Bob Phillips]

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"MartinW" <mt@bigpond.invalid> wrote in message
news:uZb1Hh7XGHA.4652@TK2MSFTNGP04.phx.gbl...
> Great link Bob, you just took my conditional formatting to a new level!
>
>

[JPG]

"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" <mt@bigpond.invalid> wrote in message
> news:uZb1Hh7XGHA.4652@TK2MSFTNGP04.phx.gbl...
> > Great link Bob, you just took my conditional formatting to a new level!
> >
> >
>
>
>