How to set alerts for issue

Question

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_e3z6as · Answer

above other point need to know how to solve this issue

Khalid Qassadi_e3z6as · Answer

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