thanks for reply
i have tried this code and found that it only fills the cell D1
if i have another value bigger than 2 in row 3 or 4 etc it does not
colour the cell
any idea how i can get it to read the columns in C an D and colour if
necessary

thaks again

kevin