adjusting code coloring some cells based on another cells

hi, guys

i would help about this error 1004 see the image

i have data in column b,c,d,i,j,k if some cells in i,j,k contains values more than values in b,c,d then colored yellow in columns,i,j,k

Quote from Carim

Hi,

You seem to over-complicate the issue ...

What is preventing you from a simple conditional formatting rule ...???

i know about conditional formatting rule but i prefer the code because of is very flexible and i try to accustom my self for codes especially i'm beginner in vba so i hope help about my problem

Quote from Carim

Hi,

Attaching a sample file would make everything much easier ..

this sample file

thanks so much you're code really work, but there is a simple problem when i add a new number even if the value of j,k,i less than values of b,c,d it colors red before i press the macro it occurs in condition there is red cell earlier exist when i write a new value in a new cell

thanks a lot carim