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

Generally forums frown upon cross posting, without a link. As most people are disinclined to respond to cross-posts because they may be wasting their time!

Cross Post

Sorry, i wasn't aware of this and didn't know how to put a link in to another post.

Problem Resolved

Thanks