software

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

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
See xldynamic.com/source/xld.CF.html#lights

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;JPGquot; gt; wrote in message
...
gt; Hi
gt; I would like to set up a period report which displays a set of milestones
gt; and measures each of them against a baseline reference giving a couloured
gt; indication: green if on track; amber say 10% out; and red, more than 10%
out.
gt; can you help
Great link Bob, you just took my conditional formatting to a new level!
Glad you liked it. Hope the OP does too lt;ggt;

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;MartinWquot; gt; wrote in message
...
gt; Great link Bob, you just took my conditional formatting to a new level!
gt;
gt;


quot;Bob Phillipsquot; wrote:

gt; Glad you liked it. Hope the OP does too lt;ggt;
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
Hi Bob amp; Martin,
Many thanks for your interest and help.
That is just what I needed very grateful.
cheers
Jack
gt;
gt; (remove nothere from email address if mailing direct)
gt;
gt; quot;MartinWquot; gt; wrote in message
gt; ...
gt; gt; Great link Bob, you just took my conditional formatting to a new level!
gt; gt;
gt; gt;
gt;
gt;
gt;