Hi,

I am trying to create a colour system based on a complicated 'Red, Amber, Green system' based on the number of 'red or green people'.

The system works like this;

Overall Red= >10% red people and <75% green people
Overall Amber= Either >10% red people and >75% green people,
or <10% red people and <75% green people
Overall Green= <10% red people and >75% green people

I am using three rows of cells for this, i.e.
Enter Red People=
Enter Green People=
Total Score

I would like the total score cell to turn Red, Amber or Green colour using the 'IF' Function or conditional formatting. However, as amber criteria as a 'OR' I cannot work out how to do this.
Can you help?
Thanks