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]
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]