Change colour of cell based on that cells number AND the colour of another cell

[Woodpusher147]

Hello
I have tried to solve this in another post without code but I cant get it to work properly so I try again.

My sheet needs to change the colour of a cell based on the colour of another cell AND the number contained within the cell I want to change.
e.g.
IF A2 is Amber AND A8 = 6 make A8 Green IF A8 =5 make A8 Yellow IF A8 = less than 5 make A8 Red If A8 = more than 6 make A8 Blue

Basically, there is an optimum(Green), >optimum (blue), minimum (yellow), < minimum (red)
These parameters would change depending on the colour of another cell, in the above case A2

The sheet pertains to staff rotas and the perfect amount of staff each day
Users will have the ability to set a colour in e.g A2, A9-A14 would show each staff members status (in - out -hols -sick etc) A8 counts the Ins and shows the number. Then the bit I need help with as above.

There are 4 situations (coloured days)
Black = 6 (no minimum)
Red = 4 (no minimum)
AMber = 3 minimum 4 Optimum
Green = 2 minimum 3 optimum

Thank you for any help

 

[Woodpusher147]

ANyone?