Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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!
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
use the current row in a list to populate a report | Excel Worksheet Functions | |||
Printing data validation scenarios | Excel Worksheet Functions | |||
How do I create a push report in Excel? | Excel Discussion (Misc queries) | |||
Linking worksheets after runnning report | Excel Discussion (Misc queries) | |||
Microsoft Access Report into Excel Spreadsheet | Excel Discussion (Misc queries) |