Conditional format colours and text upon cell condition?

Okay... here goes..!

(This is going to be used by someone who can't distinguish the colours on-screen.)
Basically, the user will enter a value in cell S5. They will also enter a value in cell C5. If the value in C5 is below 1% of the value in S5, then cell D5 needs to change to green in colour. It also needs to display the word "GREEN". If the value of C5 is between 1% and 2% of the value in S5, then it must show "AMBER" and change to an amber-type colour! If it's 2% or more, then it must show "RED" and turn red.

I think this is a relatively simple thing for all you experts, but it is completely beyond me...

I hope this makes sense!

Open the VBA editor - ALt F11
Select the tab for the sheet in which the data is going to be entered (e.g. Sheet1).

Paste the following code into the empty page

Please Login or Register  to view this content.

That's amazing... I actually managed to get it working!

Thank you Martin!

Just one question: I now need to do the same for a couple of other cells. (e.g. the same cells in rows 6,7,8 and 9) how can I duplicate this?

Just extend the code, I've added row 6 as an example

Please Login or Register  to view this content.