Ok. It's must be me..but

you get some coloured cells using a formula in Conditional Formatting rules of column D. Correct?

Isn't this the expected result?

If no, then which are the expected results and why?