# Conditional Formatting Question

#### RedMan7

##### New Member
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>

### Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

#### Fluff

##### MrExcel MVP, Moderator
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

Replies
1
Views
48
Replies
2
Views
99
Replies
5
Views
204
Replies
2
Views
235
Replies
1
Views
246

1,195,632
Messages
6,010,791
Members
441,569
Latest member
PeggyLee

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back