Conditional Formatting Question

RedMan7

New Member
Joined
Feb 15, 2019
Messages
20
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:
[TABLE="width: 536"]
<colgroup><col><col><col><col span="2"></colgroup><tbody>[TR]
[TD]Planned Submission[/TD]
[TD]Actual Submission[/TD]
[TD]Variance[/TD]
[TD]Week Number Planned[/TD]
[TD]Week Number Submitted[/TD]
[/TR]
[TR]
[TD="colspan: 5"]QA Period[/TD]
[/TR]
[TR]
[/TR]
[TR]
[TD]03/12/2018[/TD]
[TD]07/12/2018[/TD]
[TD]-4[/TD]
[TD]8[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]03/12/2018[/TD]
[TD]07/12/2018[/TD]
[TD]-4[/TD]
[TD]8[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]03/12/2018[/TD]
[TD]Not[/TD]
[TD]-[/TD]
[TD]8[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]03/12/2018[/TD]
[TD]Missing[/TD]
[TD]-[/TD]
[TD]8[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]03/12/2018[/TD]
[TD]30/11/2018[/TD]
[TD]3[/TD]
[TD]8[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]03/12/2018[/TD]
[TD]30/11/2018[/TD]
[TD]3[/TD]
[TD]8[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]03/12/2018[/TD]
[TD]30/11/2018[/TD]
[TD]3[/TD]
[TD]8[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]03/12/2018[/TD]
[TD]30/11/2018[/TD]
[TD]3[/TD]
[TD]8[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]03/12/2018[/TD]
[TD]30/11/2018[/TD]
[TD]3[/TD]
[TD]8[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]03/12/2018[/TD]
[TD]30/11/2018[/TD]
[TD]3[/TD]
[TD]8[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]03/12/2018[/TD]
[TD]30/11/2018[/TD]
[TD]3[/TD]
[TD]8[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]03/12/2018[/TD]
[TD]30/11/2018[/TD]
[TD]3[/TD]
[TD]8[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]03/12/2018[/TD]
[TD]30/11/2018[/TD]
[TD]3[/TD]
[TD]8[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]03/12/2018[/TD]
[TD]30/11/2018[/TD]
[TD]3[/TD]
[TD]8[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]03/12/2018[/TD]
[TD]30/11/2018[/TD]
[TD]3[/TD]
[TD]8[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]03/12/2018[/TD]
[TD]30/11/2018[/TD]
[TD]3[/TD]
[TD]8[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]03/12/2018[/TD]
[TD]30/11/2018[/TD]
[TD]3[/TD]
[TD]8[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]03/12/2018[/TD]
[TD]30/11/2018[/TD]
[TD]3[/TD]
[TD]8[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]03/12/2018[/TD]
[TD]30/11/2018[/TD]
[TD]3[/TD]
[TD]8[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]03/12/2018[/TD]
[TD]30/11/2018[/TD]
[TD]3[/TD]
[TD]8[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]03/12/2018[/TD]
[TD]30/11/2018[/TD]
[TD]3[/TD]
[TD]8[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]03/12/2018[/TD]
[TD]30/11/2018[/TD]
[TD]3[/TD]
[TD]8[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]03/12/2018[/TD]
[TD]30/11/2018[/TD]
[TD]3[/TD]
[TD]8[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]03/12/2018[/TD]
[TD]07/12/2018[/TD]
[TD]-4[/TD]
[TD]8[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]03/12/2018[/TD]
[TD]21/01/2019[/TD]
[TD]-49[/TD]
[TD]8[/TD]
[TD]15[/TD]
[/TR]
</tbody>[/TABLE]
 

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying
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
 
Upvote 0

Forum statistics

Threads
1,223,236
Messages
6,170,912
Members
452,366
Latest member
TePunaBloke

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top