Quadrant colour based on cell value

[RoyLittle0]

Hi,



I need help with the conditional formatting of my document, it is designed to monitor training competences, so this formatting will be used many times within this document, so it needs to be simple to copy and paste if posible.

I have 4 cells (F2, G2, F3, G3) in a Quadrant and one cell (E2) that will have a number from 0 to 5 added to it by the user, no other number should be able to be added to this cell and therefore shouldn't produce a response.

If (E2) is 0 then Cells (F2, G2, F3, G3) are blank (No knowledge)
If (E2) is 1 then Cell (F2) is Green (Poor Knowledge)
If (E2) is 2 then Cell (F2, G2) are Green (Fair Knowledge)
If (E2) is 3 then Cell (F2, G2, F3) are Green (Good Knowledge)
If (E2) is 4 then Cell (F2, G2, F3, G3) is Green (Excellent Knowledge)

If (E2) is 5 then Cell (F2, G2, F3, G3) is Red (Trainer)

Thanks in advance for your help