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

J

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
 
M

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
 
B

Bob Phillips

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
J

JPG

Bob Phillips said:
Glad you liked it. Hope the OP does too <g>
Click to expand...
Hi Bob & Martin,
Many thanks for your interest and help.
That is just what I needed very grateful.
cheers
Jack
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

formatting red amber green for copying 1
Formatting text to match Red/Amber/Green reports 0
Can I have a cell change to red/green if not equal to: 7
Can I change text data to numeric data to create charts? 3
Excel Countif Function - Calculating Between Two Sets of Values 3
Calculate % of schedule & effort slippage 7
Number of workdays between two dates 7
How do I set up a graph to show a number of different criteria? 0

Top