Conditional formatting

Hi TMShucks,

Thank you for your advice.

I have attached a dummy workbook as you suggested that hopefully shows my objectives.

A solution to the attached would be fantastic but I am frustrated with trying to apply the conditional formatting to a large sheet. If I copy and paste a row at a time the reference cell row # will change accordingly, $D4 will change to $D5 and so on but if I use ‘Filldown’ $D4 behaves as if it is $D$4. Consequently applying the format to the required cells will be very time consuming unless I can rectify this.

Many thanks in advance

julhs