hey i need a vba code for conditional formula .... i want to check
this 3 conditions for every cell through vba code ...

= 120 then red colour
<50 then orange
inbetween 50 and 120 then yellow colour