View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default 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