Formula to determine which cells to format in multiple, separate cells

Hello all,

I am newer to formulas in excel, never taking a class on it. I am trying to create a formula for my spreadsheet for work. Essentially, I am trying to create a column that has the due dates for a specific item, the column next to it (right) has the submission date. What I want to do is have the column on right (submission date) change the color of the column on the left (due date) to green once I put the date I submitted the document, see attached picture. I know how to do it individually, but I am trying to do it for the whole column without having to do each cell individually. The reason I do not want to do it individually is that this spreadsheet is of people on my caseload so it is often changing. And since I alphabetize it, the rules get messed up when I add new people and remove old people.

If this is possible, I would very much appreciate the help!

Excel Sheet.png

The reason there are duplicates is because the cell that is in column "submitted" does not always have a value in it. For example, if the date is 30+ days out, I haven't submitted the document so the cell remains blank and highlighted white. If I submit the document before its due date (which happens because of logistical reasons) then I want the cell in column "RFI Due" to change to green, signifying I have submitted it. Sometimes I can't submit the document by the due date so I submit it past due, but I still want the cell in that column to turn green as well. Hence why there is less than, equal to, and greater than. I have a rule that is the primary rule that if it's blank, its white.

It is definitely not the most efficient way to do it, but it's the only way I know how to do it. Hopefully that explains things.