Conditional Formatting Question

[RedMan7]

Hello Forumers,

I have a question about Conditional Formatting. Is it possible to format a cell with a certain fill, depending on the value of the cell on its left?

I need to format the cells in the column titled: Actual Submission (Might say Actial on the screenshot - typo) I need to format it based on the date on the left (Column titled Planned Submission) However, when I apply a new rule, it only lets me select one cell - This won't allow me to format correctly. Is there a way to do this?

Thank you very much!

Here is a Screenshot:
https://unsee.cc/5c74cf95/

Here is the table:

Planned Submission	Actual Submission	Variance	Week Number Planned	Week Number Submitted
QA Period
03/12/2018	07/12/2018	-4	8	8
03/12/2018	07/12/2018	-4	8	8
03/12/2018	Not	-	8	-
03/12/2018	Missing	-	8	-
03/12/2018	30/11/2018	3	8	7
03/12/2018	30/11/2018	3	8	7
03/12/2018	30/11/2018	3	8	7
03/12/2018	30/11/2018	3	8	7
03/12/2018	30/11/2018	3	8	7
03/12/2018	30/11/2018	3	8	7
03/12/2018	30/11/2018	3	8	7
03/12/2018	30/11/2018	3	8	7
03/12/2018	30/11/2018	3	8	7
03/12/2018	30/11/2018	3	8	7
03/12/2018	30/11/2018	3	8	7
03/12/2018	30/11/2018	3	8	7
03/12/2018	30/11/2018	3	8	7
03/12/2018	30/11/2018	3	8	7
03/12/2018	30/11/2018	3	8	7
03/12/2018	30/11/2018	3	8	7
03/12/2018	30/11/2018	3	8	7
03/12/2018	30/11/2018	3	8	7
03/12/2018	30/11/2018	3	8	7
03/12/2018	07/12/2018	-4	8	8
03/12/2018	21/01/2019	-49	8	15

<colgroup><col><col><col><col span="2"></colgroup><tbody>
</tbody>

 

[Fluff]

Assuming your first date is in A3 select B3 to B last row, and Use a formula
Where the formula could be =$A3< TODAY()-30