I have been trying to work out how to go about calculating multiple
conditionals using the Wizard. In MS 2003 you can use the Add button.......in
2007 it seems to have disappeared???
I was hoping to be able to calculate the following for a Risk spreadsheet.
For each RED, AMBER, GREEN (RAG) cell (manually filled with appropriate
colour), I want to automatically work out the RAG status and fill with colour
(or use traffic ligts) based on the following.

Example:
the RAG cell is B8 (I wish to calculate this automatically)
I have a Severity cell I8 and Probability Cell J8
There are 3 levels, H (HIGH), M (MEDIUM), L (LOW). I manually populate these
values.

The conditions a
If I8 is equal to H and J8 is equal to H then B8 should have a fill of RED
If I8 is equal to H and J8 is equal to M then B8 should have a fill of RED
If I8 is equal to M and J8 is equal to H then B8 should have a fill of RED

If I8 is equal to M and J8 is equal to M then B8 should have a fill of AMBER
If I8 is equal to M and J8 is equal to L then B8 should have a fill of AMBER
If I8 is equal to L and J8 is equal to M then B8 should have a fill of GREEN

If I8 is equal to L and J8 is equal to L then B8 should have a fill of GREEN
If I8 is equal to L and J8 is equal to M then B8 should have a fill of GREEN
If I8 is equal to M and J8 is equal to L then B8 should have a fill of GREEN

Is there a simple way to do this? Thanks in advance