How to set alerts for issue

[Khalid Qassadi]

Dear,

I'm working on dashboard and I'm try to set the alerts for issue before due date or not started date & I'm write the query is 

(Received Date >=5d OR Target end >= 30d will take red color as alert

Received Date >=3d AND Received Date <=4d OR Target end >=16d AND Target end <=29d will take Yellow color as alert

Received Date >=1d And Received Date <=2 OR Target end >=1 AND Target <=16d will take Green color)

to be aware I have the Received date & target end & all of them in one query is above I need advice how to solve this.

[Khalid Qassadi]

in addition, if the issue not started & take red color then started the status will green color in one column how to change the color status automated without repeated colors in the same column

[Khalid Qassadi]

above other point need to know how to solve this issue