I have need the below conditional formatting for the below rules:
green Due by = End date and status = Completed
yellow Due by < End date + 3 and status = Completed/In Progress
red Due by > sysdate and status = Not Started
red Due by > End date + 4 and status = Not Started/In progress
Attached is my sample xls file.