RAG Rating

G

Guest

An example of RAG Rating might be sales against target. If sales are more
than 5% off target the cell should be shaded Red, within 5% of target the
cell should be Amber or on targtet the cell should be shaded green. Does
anyone know if its possible to reflect the above in a Data Table within an
Excel graph? Right now I copy the graph into a graphics package, shade it
then paste into a presentation but there has to be a better way.
If the answer lies with VB, my skills are non-existant so please be gentle.
 

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

Conditional formatting based on adjacent cell? 1
Multiple Conditionals in MS Excel 2007 6
Help with RAG Formula 4
Countifa RAG auto populating data 0
Datagrid Questions 1
How do I use a Defined Name range for a value series in a chart? 1
Need assistance with how or even if this is possible (function) 8
A Challenging Charting Qustion - Are there any Brainiacs Among Us? 2

Top